[solved] How to setup charset
lazarus / 16-Databases

----------------------------------------------------------------------
isadjuk · 2009-02-19 12:00

Hello !!
I'm connecting to database where strings are as "utf8_general_ci" and
I need to read/write texts with polish characters.

How to do it? Tried to set connection charset as utf8 and cp1250, I
used Utf8ToAnsi and AnsiToUtf8 when selecting and importing data.
When I read data should I also set target field (ex. TMemo) charset to
another?

----
After connection to database I did:
Code: [Select]query.SQL.Text := 'SET NAMES 'cp1250';and ExecSQL. All
characters are displaying (r/w) now correctly.