mORMot Open Source

slan2026

Member

Registered: 2026-02-03

Posts: 5

orm to mssqlserver reported 'sql_variant' to 'bigint' was not allowed

When I changed the backend database to mssqlserver and inserted data, it reported that implicit conversion from data type 'sql_variant' to 'bigint' was not allowed.
The mssqlserver tracking prompt is as follows: "declare @ p1 int
set @p1=NULL
exec sp_prepare @p1 output,N'@AA SQL_VARIANT,@BA SQL_VARIANT,@CA SQL_VARIANT,@DA SQL_VARIANT,@EA SQL_VARIANT,@FA SQL_VARIANT,@GA SQL_VARIANT,@HA SQL_VARIANT',N'insert into dbo.Article (ID,Title,Author,Content,CreatedAt,UpdatedAt,ViewCount,Published) values (@AA,@BA,@CA,@DA,@EA,@FA,@GA,@HA)',1
select @p1“
Help, where should I fix this error

Last edited by slan2026 (Today 09:08:17)