var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select UTF-16 from an UTF-8 database
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?
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')
Ex2. Converts the string "Test" from character set UTF-8 to UTF-16
SELECT CONVERT('Test', 'AL16UTF16', 'UTF8')
This however didn't work for me as my database doesn't support the AL16UTF16 character set.
Last edited by matsnas; 07-04-03 at 09:12.