Codepage WIN1251

[samsuser]

Hi

I have delphi project working with Interbase tables with  collate WIN1251 .
I convert  it to Lazarus .
When i open my Interbase tables with components SQLdb from Lazarus ,
I can not read the contents of fields table because they are distorted
We'll see garbled characters
how to solve the problem?

many thanks


PS

 The exact same problem when opening a DBF  spreadsheet with the coding DOS 866. ( dBASE RUS cp866)

[bobo]

Lazarus works only with UTF-8 strings, so all components expect that.
I do not know about the SQLDB components coming with Lazarus, but if you use ZEOS instead, you can set the client code page to UTF-8 and see your DB data properly in Lazarus programs.
You can put a "codepage=UTF8" in the ZConnection.Properties to accomplish this.

I use the following for MySQL:

Code: [Select]

...
      SQLConnection.Properties.Text :=
        'character_set_client=utf8'#13#10+
        'character_set_connection=utf8'#13#10+
        'character_set_database=utf8'#13#10+
        'character_set_results=utf8'#13#10+
        'character_set_server=utf8'#13#10+
        'character_set_system=utf8'#13#10+
        'collation_connection=utf8_general_ci'#13#10+
        'collation_database=utf8_general_ci'#13#10+
        'collation_server=utf8_general_ci'#13#10+
        'Codepage=utf8';
...
and both reading and writing are ok , even with non UTF-8 databases.
It can be different for your database though...

[samsuser]

Sorry,  could you do a little example ?

[circular]

These properties affect the connection in general. Then when you do SELECT, INSERT etc. you will get data in the UTF8 format.

[samsuser]

Lazarus works only with UTF-8 strings, so all components expect that.
I do not know about the SQLDB components coming with Lazarus, but if you use ZEOS instead, you can set the client code page to UTF-8 and see your DB data properly in Lazarus programs.
You can put a "codepage=UTF8" in the ZConnection.Properties to accomplish this.

I use the following for MySQL:

Code: [Select]

...
      SQLConnection.Properties.Text :=
        'character_set_client=utf8'#13#10+
        'character_set_connection=utf8'#13#10+
        'character_set_database=utf8'#13#10+
        'character_set_results=utf8'#13#10+
        'character_set_server=utf8'#13#10+
        'character_set_system=utf8'#13#10+
        'collation_connection=utf8_general_ci'#13#10+
        'collation_database=utf8_general_ci'#13#10+
        'collation_server=utf8_general_ci'#13#10+
        'Codepage=utf8';
...
and both reading and writing are ok , even with non UTF-8 databases.
It can be different for your database though...

 How about UIB  component ?
 Where use thise code ?

[bobo]

Codepage=utf8

should work with IB too. The Zeos "TZConnection" component (SQLConnection above in the code snippet) has - among others - a "Protocol" property where you can set the database connection type. "mysql-5" or "interbase-6" or "firebird-2.5", etc.
The best if you test it first with a simple example application.

[samsuser]

Is that correct  ?

   http://project1.fo.ru/image/1014/5506_screenshot_000005.jpg