Zeoslib Portal

I finally get the answer ! Reason is that mysql use Latin1 to store data character_set_database = latin1 So in Delphi7 : ws := '環保及資源管'; // which was some Chinese character sql := 'insert into DB_123 values (''' + utf8encode(ws) + ''')'; the widestring will first encoded as utf8 and send via the mys...

Forgot to mention that my Zeos version was 7.0.3 stable

Hi, I just upgraded from Delphi7 to XE3. I was having trouble in doing insert/update SQL to my mysql server. In delphi7, if I want to save a utf8 field in mysql DB I will do this : ws : widestring; sql : string; ws := '環保及資源管'; // which was some Chinese character sql := 'insert into DB_123 values ('...

Below is my experience : If I have the following configuration : ASA host : 10.1.1.1 Server name : ASA_Server username : user password : ppp Database : dbname Then I will call the Zeosdb API as below : Connection := DriverManager.GetConnection( 'zdbc:ASA9://ASA_Server:3268/?' + 'uid=user;pwd=ppp;lin...