Zeoslib Portal

Thanks for the contribution of EgonHugeist. The utf-8 problem had been resolved for mysql for chinese characters. The only thing have to do is set clientcodepage to be utf8.

Finally, I noticed that I can successfully insert all characters when I change the "Language for Non-Unicode Programs" from Chinese to English. That was strange.

Anyone have ideas ?

EgonHugeist,

Please check PM message.
Thanks.

Hi EgonHugeist,

I have tried your latest trunk, but I experience problem when saving Chinese characters using zeoslib. I am using Delphi XE2 update4.
The problem is exactly the same is the below post. Some characters are missing.
http://zeos.firmos.at/viewtopic.php?p=12834

Any idea?

Hi EgonHugeist,

Just find your reply, haven't check this forum for a while.
It's great to see someone notice my sharing, although my code is dirty.
I also hope ZeosLib Dev Team can notice the UTF8 problem and check to see if the fix can help.
Anyway, thanks for your reply.

I have the following findings now. The following will result in corrupted string. PAnsiChar(UTF8Encode('我是')); However, the result of following is ok. PAnsiChar(AnsiString('我是')); I guess PAnsiChar is not capable to store some chars in East Asian Language. Now I tried to modified the source src/plai...

Now, I followed adaptec's idea to trace. I find that some chinese characters cannot be decoded successfully. For example: Value1:=PAnsiChar(UTF8Encode(Text1)); Value2:=UTF8Decode(Value1); The resulting Value2 is not equal to Text1. For example, The character "我是" is not able to convert suc...

I have already tried codepage=utf8. still not working. Many chinese characters turn into '?'.

I have already download latest version from svn://zeos.firmos.at/zeos/trunk. Now, I still find zeosdbo seems cannot update Mysql when using some chinese characters when using UTF-8. All the chinese characters can be read from database. I am using Delphi 2010 with the following properties: character_...