27 July 2017

How to setup Unicode fields and variables in Delphi with UniDAC and MS SQL Server

To get Unicode characters in Delphi UniDAC and other controls you must convert next database field types :
  • Char -> NChar
  • VarChar -> NVarChar
  • Clob -> NClob
You can convert those fields automatic with ESF Database Migration Toolkit and in the "Data Type" page of "Setting" dialog: Checking "Transfer To National Type".


Also, then in Delphi you have to convert all database fields and code variable types :
  • String -> WideString
And after that actions - you will get full Unicode in all UniDac and other controls, even in design mode.




No comments: