Select UTF-16 from an UTF-8 database

matsnas · #1 (**permalink**) 07-02-03, 10:23

Hi!

I have a 8.1.7 (at least I believe it is...) database set-up as UTF-8. I need to create a result which is returned as UTF-16.

Is it possible to temporarily set the encoding to UTF-16 or perhaps even convert it in the select statement?

/Thnx

matsnas · #2 (**permalink**) 07-03-03, 06:10

Just thougt I'd reply a soulution if anyone is looking for the same thing.

If you have an Oracle 9i or better one soulution counld be to use the following syntax:

Ex1. Converts the string "Test" from default character set to UTF-16
SELECT CONVERT('Test', 'AL16UTF16')
FROM DUAL

Ex2. Converts the string "Test" from character set UTF-8 to UTF-16
SELECT CONVERT('Test', 'AL16UTF16', 'UTF8')
FROM DUAL

This however didn't work for me as my database doesn't support the AL16UTF16 character set.

/...