== Quote from howa (howachen@gmail.com)'s article
> Hello,
> Is it possible to use MySQL to convert from one encoding to another,
> e.g.
> CONVERT('¤¤°ê' USING big5)
> assume the original string is in UTF8, I want to convert to big5
> can't make this work yet...
> Thanks.


yes, it is. try this:

select convert(col1 using big5) from table


--
POST BY: lark with PHP News Reader