Problem with nvarchar(max) in dbexpsda.dll

jsdawson · Post by **jsdawson** » Thu 26 Jul 2007 23:22

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

Antaeus · Post by **Antaeus** » Fri 27 Jul 2007 16:58

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).