Unicode with Fb2.1 and D2009
Posted: Wed 18 Feb 2009 18:57
Hi,
I am using latest dbx driver for Ib and Firebird 2.1 with Delphi 2009.
My SQLConnection like this:
In Devart readme, it say:
Of course it cannot show my Chinese characters in the database.
Any suggestion?
I am using latest dbx driver for Ib and Firebird 2.1 with Delphi 2009.
My SQLConnection like this:
Code: Select all
object conInterbase: TSQLConnection
ConnectionName = 'Devart InterBase'
DriverName = 'DevartInterBase'
GetDriverFunc = 'getSQLDriverInterBase'
LibraryName = 'dbexpida40.dll'
LoginPrompt = False
Params.Strings = (
'DriverName=DevartInterBase'
'DataBase=C:\DB\Crazy.fdb'
'RoleName='
'User_Name=sysdba'
'Password=masterkey'
'SQLDialect=1'
'BlobSize=-1'
'ErrorResourceFile='
'LocaleCode=0000'
'DevartInterBase TransIsolation=ReadCommited'
'WaitOnLocks=True'
'Charset='
'CharLength=1'
'EnableBCD=True'
'OptimizedNumerics=True'
'LongStrings=True'
'UseQuoteChar=False'
'FetchAll=False'
'UseUnicode=True')
VendorLib = 'gds32.DLL'
Left = 24
Top = 384
end
But why I add all fields to my dataset, it show all fields are TStringField and TMemoField? Why not TWideStringField and TWideMemoField?
UseUnicode
Enables or disables Unicode support. Affects character data fetched from the server. When set to True all character data is stored as WideStrings and TStringField is replaced with TWideStringFiled.
This option is available for Delphi 2006 and higher IDE versions.
Default value of this option is True for Delphi 2009 and higher IDE versions, and False for Delphi 2006 and 2007.
Of course it cannot show my Chinese characters in the database.
Any suggestion?