Re: special characters
Posted by: Rick James
Date: June 19, 2010 12:15AM

And what do you get from
SELECT HEX(t) FROM test;
I expect 0101, which is the hex equivalent of 257.

Recommend you use HEX and UNHEX instead of CHAR and CAST.

If you really need the decimal:
SELECT CONV(HEX(t), 16, 10) FROM test;

Options: ReplyQuote


Subject
Views
Written By
Posted
4747
June 17, 2010 09:55AM
Re: special characters
1824
June 19, 2010 12:15AM
2251
June 23, 2010 12:05AM


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.