Re: Can not get proper utf8 text
This actually works:
CONVERT(UNHEX(HEX(CONVERT(CONVERT(member_username USING utf8) USING latin1))), CHAR)
At first I thought CONVERT(something, CHAR) only would only work for converting single character or I had to specify the maximum length of a string field. That's not the case.
Bob
Subject
Written By
Posted
Re: Can not get proper utf8 text
June 09, 2011 01:40PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.