[mapguide-users] Chinese text on feature lable are incorrect, feature data source is MySQL

[Dave Wilson]

You should ensure that your table definition uses the UTF8 charset. You
may have to do an alter table to change the charset before you insert
the data. I'm not sure that doing an alter after the table is populated
will work. You may be able to create a database and set the charset
default to UTF8 before you create any tables.

The MySQL FDO provider should have no problems retrieving double byte
data. Note if you plan to use ODBC for MySQL their 3.51 ODBC connector
(driver) does NOT support double byte characters according to their own
documentation.

Regards,
Dave

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of fishtrees
Sent: Tuesday, May 15, 2007 1:14 PM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Chinese text on feature lable are incorrect,
feature data source is MySQL


THX for help.

I'm not sure in this mail list how many friends can meet same problem,
but I
really want  to solve this problem.

I already use the unicode font,but it's no effect,chinese text on
feature
lable always display "???".
If I use SHP files as my feature resource, chinese text can be displayed
correct. 
I guess the reason is that FDO MySQL provider only supports single byte
character.
If that is true, how can I add a MySQL query "set names utf8" after
create a
MySQL connection or before some other operation like "select".

Is there someone can give me some suggestion?

FishTrees
-- 
View this message in context:
http://www.nabble.com/Chinese-text-on-feature-lable-are-incorrect%2Cfeat
ure-data-source-is-MySQL-tf3760491s16610.html#a10629193
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users