Greetings!<br><br>I'm trying to setup a mapserver that supports multiple languages with MySQL. The database uses UTF-8, while the map server use a select statement to retrieve records. The layer goes as:<br><br> LAYER
<br> NAME sr<br> STATUS OFF<br><br> TYPE POINT<br> CONNECTIONTYPE OGR<br> CONNECTION "<OGRVRTDataSource>
<br> <OGRVRTLayer name='sr'><br> <SrcDataSource>MYSQL:MapSQL,user=root,password=123456,host=localhost,port=3306,tables=POI</SrcDataSource>
<br> <SrcSQL>SELECT `Name`, geom FROM `POI` WHERE `ID` = %o%</SrcSQL><br> <GeometryType>wkbPoint</GeometryType>
<br> </OGRVRTLayer><br> </OGRVRTDataSource>"<br> DATA "sr"<br> UNITS METERS
<br><br> MAXFEATURES 1<br> LABELITEM "Name"<br><br> CLASS<br> SYMBOL "point"<br> MINSIZE 10<br>
COLOR 250 0 0<br> OUTLINECOLOR 0 128 0<br><br> LABEL<br> ENCODING "utf-8"<br> COLOR 255 0 0
<br> OUTLINECOLOR 255 255 255<br> TYPE TRUETYPE<br> FONT arial<br> SIZE 8<br> ANTIALIAS TRUE
<br> POSITION UC<br> PARTIALS FALSE<br> BUFFER 5<br> FORCE TRUE<br> END<br> END<br> END
<br><br>All Chinese characters are shown as question marks (?) on the map, no mater using arial or Chinese fonts.<br><br>Any advise?<br><br>