[SOLVED] SQLdb accented characters display problem

[JD]

Hi there,

I'm trying to read data from a Firebird database using sqldb's TSQLQuery but accented characters show as "?". Below are the parameters I'm using for connecting to the database.

Code: [Select]

    // Les autres parametrès de connexion
    with Params do
    begin
      Add('character_set_client=utf8');
      Add('character_set_connection=utf8');
      Add('character_set_database=utf8');
      Add('character_set_results=utf8');
      Add('character_set_server=utf8');
      Add('character_set_system=utf8');
      Add('collation_connection=utf8_general_ci');
      Add('collation_database=utf8_general_ci');
      Add('collation_server=utf8_general_ci');
      Add('Codepage=utf8');
      Add('isc_tpb_read_commited');
      Add('isc_tpb_concurrency');
      Add('isc_tpb_nowait');
    end;

It is almost identical to what I used for a Zeos connection BUT the Zeos' TZQuery was able to display accented characters properly.

What am I missing? What do I have to do to make TSQLQuery display accented UTF8 characters properly?

Thanks,

JD

[LacaK]

Try set TIBConnection.CharSet := 'UTF8';

[JD]

Try set TIBConnection.CharSet := 'UTF8';

Thanks a lot. It worked!