Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    3

    Question Unanswered: Select UTF-16 from an UTF-8 database

    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

  2. #2
    Join Date
    Jul 2002
    Posts
    3

    Solution

    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.

    /...
    Last edited by matsnas; 07-04-03 at 10:12.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •