Page 1 of 1

So UTF-8 WORKS or NOT?

Posted: 22.05.2011, 18:43
by Tommix
I saw in forum many, many people have problems with encoding. My SQLite 3 data file uses UTF8 encoding, but this awesome component returns strange chars, not the ones should be. I added bunch of lines in connection properties-does not help.

Code: Select all

character_set_client=utf8
character_set_connection=utf8
character_set_database=utf8
character_set_results=utf8
character_set_server=utf8
character_set_system=utf8
collation_connection=utf8_general_ci
collation_database=utf8_general_ci
collation_server=utf8_general_ci
Codepage=utf8
SO does this component have support for UTF8 or not? Why it's not working for everybody?

Posted: 23.05.2011, 18:25
by Dali
Well, I use Zeos for postgresql, and it works fine in version 6.6.6 with patches from svn simply adding the property "codepage=utf8".

With version 7 alpha it does NOT work yet (as for svn 903). At least, not in Lazarus. There are many changes to be made in many places using compiler conditional directives (stUnicodeString for stString IFDEF FPC, since FPC and hence Lazarus use only UTF-8 for the presentation layer).

Of course, it's understandable. It's an alpha version, not intended for use in production, and now there are quite few people working on it. I'll keep on testing it, but currently I am not skilled enough to contribute in any other way.