Page 1 of 1

Problem with nvarchar(max) in dbexpsda.dll

Posted: Thu 26 Jul 2007 23:22
by jsdawson
I just downloaded the latest version of dbexpsda.dll (4.0.0.2) hoping that it would make my Delphi 7 app compatible with SQL Server 2005 nvarchar(max) columns. Unfortunately, wide characters like Kanji are still being displayed as question marks.

Do I need to make any application changes in order to use the new nvarchar(max) compatibility?

Thanks in advance,
John

Posted: Fri 27 Jul 2007 16:58
by Antaeus
This is a restriction of dbExpress of Delphi 7. Unicode is supported in dbExpress starting with Delphi 2006.
You should either upgrade your IDE, or switch to SDAC.
You should also use a DB-aware controls with Unicode support (like TNT controls).