Zeoslib Portal

Posted: **22.02.2019, 14:07**

Hello
Last time I changed Delphi 2007 to 10.3Rio and I have problem with display polish letters from Firebird on DBGrid and Edits etc.
I have database with character set WIN1251and on Delphi 2007 it works ok with:

Code: Select all

object ZConnection1: TZConnection
    ControlsCodePage = cGET_ACP
    AutoEncodeStrings = False
    Properties.Strings = (
      'lc_ctype=WIN1250'
      'controls_cp=GET_ACP')

...
Collation is not good but other things works for me ok.
When I compile the same project on Delphi 10.3 and connect to database I haven't polish signs.
I trying different settings and it not help me.
I can't change AutoEncodeStrings = False because always is True (on Delphi2007 is set to False).
In future I am planning change database to UTF8 but now I need to work on existing database WIN1251.
I tested on ZeosLib 7.2.4 and 7.3.
Can somebody help me what I must to change or what settings to test.
Many thanks.
Robert

Posted: **23.02.2019, 13:35**

Hello,

what setting do you have for ClientCodepage? For Unicode Delphis the following should work:

Code: Select all

object ZConnection1: TZConnection
    ClientCodepage=UTF8
    ControlsCodePage = cCP_UTF16
    AutoEncodeStrings = True

Properties should not contain a line with lc_ctype=.

Best regards,

Jan

Posted: **25.02.2019, 08:23**

I guess where you said 1251 should be 1250 cause 1251 is Cyrillic that doesn't have Polish symbols. But anyway check again you haven't confused them

Zeoslib Portal

Delphi 10.3Rio to Firebird - lang problem

Delphi 10.3Rio to Firebird - lang problem

Re: Delphi 10.3Rio to Firebird - lang problem

Re: Delphi 10.3Rio to Firebird - lang problem