Charset Problem SQLite

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

Moderators: gto, EgonHugeist

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

Charset Problem SQLite

Postby jjeffman » 25.04.2013, 21:28

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
Gold Boarder
Gold Boarder
Posts: 589
Joined: 17.01.2011, 14:17

Postby marsupilami » 30.04.2013, 16:36

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
Contact:

Postby jjeffman » 30.04.2013, 19:08

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


Return to “6.6 - stable”

Who is online

Users browsing this forum: No registered users and 1 guest