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>