10 January 2012

Oracle Encoding functions

Salam,

Actually I am not interested in Oracle DB programming, but I use it some times so, I'll list here two handy functions that I use.

To get character ASCII code, use:
select ascii('a') from dual

To get the character from a code page (according to DB local encoding), use:
select chr(176) from dual


Post a Comment