[SOLVED] SQLdb accented characters display problem
lazarus / 16-Databases

----------------------------------------------------------------------
JD · 2015-04-03 08:37

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 · 2015-04-03 17:09

Try set TIBConnection.CharSet := 'UTF8';

----------------------------------------------------------------------
JD · 2015-04-03 21:09

Quote from: LacaK on April 03, 2015, 07:09:48 pmTry set
TIBConnection.CharSet := 'UTF8';

Thanks a lot. It worked!