mORMot Open Source

slan2026

Member

Registered: 2026-02-03

Posts: 6

Implicit conversion from varchar(max) to varbinary(max) is not allowed

Help
When I run the code in mormot2\ex\mvc-blog on my computer, and changed the backend database to mssqlserver and inserted data, it reported that: TOdbcLib error: [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server] Implicit conversion from data type varchar(max) to varbinary(max) is not allowed.
(8180)\r\n",Statement:{Sql:"insert into dbo.Article (ID,CreatedAt,ModifiedAt,Title,Content,ContentHtml,Author,AuthorName,PublishedMonth,abstract,Tags) values (?,?,?,?,?,?,?,?,?,?,?)",SqlWithInlinedParams:"insert into dbo.Article (ID,CreatedAt,ModifiedAt,Title,Content,ContentHtml,Author,AuthorName,PublishedMonth,abstract,Tags) values (5,135969775136,135969775136,'Plu bli cho chu blo. ','Pha cho, cha ble chi bli? Plu cha bli cho cho chi bla bla chi chi blo cha che blo ble blo cha chi blu blo chi cho bli.\r\nPhi bla cho bli cho cho. Plo bli chi cha, cho bla blo bla chi blo chi bla chi bli, che cha blo, chi ble cho.\r\nPli chi blo bli, blo cho che bli bli, chu cho cho bli chi.\r\nPlu bla che bla blu. Pho bla bla bla, blu bli https://synopse.info bla chu che cho chi chi chi chi bli ble bla blo bli che chu chi blo cha cho https://synopse.info chi che chu cha blo. Phi bla chi bla blo cho blo blo chu cha cha, bla bli chi chu blo, bli cho https://synopse.info cho blu cho bli bli chi blu che cha? Pha cha, cha blu bli blo chu blo.\r\nPho cha bla blo bla bla bli chi cho bli blu, bli cha bli cho blo blo che bli cho blo cho https://synopse.info cha bli. Plu bli blu bla chu. Pha blo chi blu che, chu che cho che bla. Plu che, cho cho chi che chu chu bla. Plo bli cho blu bla chi che.\r\nPhi chi chu blu cha cho bla.',0,1,'synopse',24168,'Pla cho cho, cha chi bla bli chu cha bla cha chi, bli bla cho, cho chu blu bli che, ble cha bli.\r\nPlu blu? Phi chi bla bli chi bla!',null)"
the field Tags is TIntegerDynArray. When insert into “null” can not  convert to blob.

danielkuettner

Member

From: Germany

Registered: 2014-08-06

Posts: 403

Re: Implicit conversion from varchar(max) to varbinary(max) is not allowed

Are you sure varchar(max) is right for array of integer when using mssql?
It's clearly not an mORMot issue.