Just in case someone comes across this problem , I found a solution by saving my mapfile in shift-jis and including a client_encoding option in my connection string as follows :
CONNECTION "user=postgres dbname=mydb host=localhost port=5432 options='-c client_encoding=SJIS'" Donal wrote: > > I have a map file saved as shift-jis which allows to me query some shape > files that have attributes encoded in shift-jis i.e I can write a > classitem in shift-jis encoded japanese and my map displays as I would > like. > > I now have a postgresql db encoded in UTF-8. I want to filter the data > coming back but my column names are in UTF-8 encoded japanese. So when I > set my FILTER to something like "内容=1" I get the folowing > error: > > Postgresql reports the error as 'ERROR: invalid byte sequence for > encoding "UTF8": 0x93 ' > > If I save my mapfile as UTF-8, no db error occurs, but now I can't match > the attributes in shapefiles. > > Is there a way around this? > > Thanks, > > Donal > > > > > --------------------------------- > Inbox full of spam? Get leading spam protection and 1GB storage with All > New Yahoo! Mail. > -- View this message in context: http://www.nabble.com/mapfile-in-shift-jis%2C-db-in-utf-8-question-tf2071627.html#a8273244 Sent from the Mapserver - User mailing list archive at Nabble.com.