Oracle string functions
The CONVERT function converts a string from one characterset to another. The datatype of the returned value is VARCHAR2.
Example: CONVERT('This is an example','UTF-8','WE8ISO8859P1' )
SELECT CONVERT('Ä Ê Í Ó Ø A B C D E ', 'US7ASCII', 'WE8ISO8859P1') FROM DUAL;
-------------
A E I ? ? A B C D E ?
No comments:
Post a Comment