[patch_done] Setting up Unicode connection with Zeos 7

[KingS]

Hello,

today I switched to Zeos 7 (SVN-Builds) in order to use Delphi 2009. But now I have some questions because I have to convert the strings from/to database - and I don't know why. Data will be stored correctly, but when I load data from DB "Müller" becomes mostly unreadable (you know what I mean

Firstly, my settings/environment:

Code: Select all

Database: Firebird 2.1
Collate/Charset: UTF8
ZConnection.Properties.Add('codepage=utf8');
ZQuery.Properties.Add('codepage=utf8');

That's all I had to set up.

How I store data:

Code: Select all

...VALUES (:data1, :data2, :data3.......
ZQuery.ParamByName('data1').AsString:='äöü';

Remember: In Database "äöü" is stored correcty.

How I read data:

Code: Select all

...SELECT * FROM ....
result:=ZQuery.FieldByName('test1').AsString;

The result from the read-function is "string" (Delphi 2009)

This will end up in encoding-display-errors. When I convert with "UTF8ToString", everything is fine.

Is this behaviour correct?

Thanks in advance!

[mrLion]

try fieldByName().AsWideString ????

[ism]

What sql server, what encoding tables ?

[seawolf]

They are talking about firebird

[ism]

For delphi maybe for example
codepage=cp1251
for russian text

[EgonHugeist]

use http://zeos.firmos.at/viewtopic.php?t=3427