Re: Weird utf-8 encoding problem using webserver that does not occur in command line client
Posted by: Stefan Helders
Date: July 02, 2009 04:31AM

Yes, I put the header correctly. For this reason the one of the two characters appears correctly. Only the character selected from the table is wrong.

Using the HEX-Function:

select HEX(CHAR(50603)), HEX(substr(name,5,1)) from names where nameid=19028;

In both cases C5AB is displayed.

select CHAR_LENGTH(CHAR(50603)), CHAR_LENGTH(substr(name,5,1)) from names where nameid=19028;

Here the result is different: 2 in the first case, and 1 in the second case.

Options: ReplyQuote




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.