Author Topic: [solved] How to setup charset  (Read 2715 times)


  • Newbie
  • Posts: 1
[solved] How to setup charset
« on: February 19, 2009, 01:00:20 pm »
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.
« Last Edit: April 07, 2009, 12:05:00 pm by isadjuk »


TinyPortal © 2005-2018