working with database in UTF-8

[Jackey Cheung]

hmm, yes, you've reminded me 'bout the box and question marks. thx.

Currently, all data in the mysql database use utf8, and I'm running a wfs 
server with the same data, which seems fine. I can use openlayers running in 
ie or firefox to retrieve data and show them correctly on screen, using utf8 
encoding. Question marks show up only in mapserver generated images.

Any advise how can I pin down the cause of this problem?


----- Original Message -----
From: "Paul Hastings" <paul at sustainableGIS.com>
To: "Jackey Cheung" <cheung.jackey at GMAIL.COM>
Cc: <MAPSERVER-USERS at LISTS.UMN.EDU>
Sent: Wednesday, June 27, 2007 10:09
Subject: Re: [UMN_MAPSERVER-USERS] working with database in UTF-8

> Jackey Cheung wrote:
>> Well, it shows a bunch of question marks (?) no matter I use arial or 
>> big5 fonts. I don't know how to check out the encoding of fonts, and I 
>> don't know which font to use for the case.
>
> ? indicate that your data is garbaged somewhere along the line, usually 
> from a serious encoding mismatch. mojibake (@$%!?<+~ etc.) usually means 
> simple encoding mismatch. if you see boxes instead of chars, that's a font 
> issue.