Charset Problem SQLite

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
jjeffman
Senior Boarder
Senior Boarder
Posts: 56
Joined: 25.08.2005, 12:40
Location: Porto Alegre

Charset Problem SQLite

Post by jjeffman »

I am using Zeos 6.6 stable on C++Builder 6.0 on Professional edition.

The SQLite database has charset UTF8. When I run queries using SQLite Expert I can retrieve correct Portuguese charactars. The TZQuery is retrieving data with ANSI characters and "ç" is being retrieved as "ç".

I have asked SQLite Expert support and they suspect that Zeos is making an extra charset conversion when calling function TZSQLiteResultSet.GetString(ColumnIndex: Integer): String;

Can you please help me?

Best regards
Jayme Jeffman Filho

DBA, Software Engineer
Sul Engenharia e Sistema Ltda

http://www.sulenge.com.br
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Post by marsupilami »

Hello jjeffman,

could you post your code for saving and also for displaying the data in the database?
Best regards,

Jan
jjeffman
Senior Boarder
Senior Boarder
Posts: 56
Joined: 25.08.2005, 12:40
Location: Porto Alegre

Post by jjeffman »

I think I have answered your post at http://zeos.firmos.at/viewtopic.php?p=17231#17231.

Best regards,
Jayme Jeffman Filho

DBA, Software Engineer
Sul Engenharia e Sistema Ltda

http://www.sulenge.com.br
Post Reply