UniDAC unicode with Firebird 2.1

[lams]

Hi,

I am testing UniDAC 2.0 with Firebird 2.1 under D2009 SP2.

Here is my UniConnection:

Code: Select all

  object UniConnection1: TUniConnection
    ProviderName = 'InterBase'
    Database = '/var/local/data/crazy.gdb'
    SpecificOptions.Strings = (
      'InterBase.UseUnicode=True'
      'InterBase.CharLength=1'
      'InterBase.SQLDialect=1')
    Username = 'sysdba'
    Password = 'masterkey'
    Server = 'zephir.local'
    LoginPrompt = False
    Left = 120
    Top = 40
  end

I can connect to my database without any problem. But all my fields in UniQuery are TStringField and TMemoField. It seems not support unicode at all.

Any thing I miss?

Cheers,

[Plash]

Probably the problem occurs because all fields in your database have NONE character set. UniDAC cannot be sure that such fields contain UTF8 data, so UniDAC does not decode data in these fields.

We'll change this behavior in the next build of UniDAC. UniDAC will decode data in fields with NONE character set from UTF8 when the UseUnicode option is set to True. In this case TWideStringField fields will be created.