dbTalk Databases Forums  

Select UNICODE (UTF8) data as octets from database

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Select UNICODE (UTF8) data as octets from database in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
OracleServer
 
Posts: n/a

Default Select UNICODE (UTF8) data as octets from database - 04-18-2007 , 02:49 AM






Hi.
My database (10g) has been created with database character set to
"Unicode standard UTF-8 AL32UTF8".

The data has been stored correctly. Used select dump(name, 1016)
from...
Query returned:
Len = 3 CharacterSet=AL32UTF8: e4, b8, 84
UTF-8 encoding of Unicode character (Traditional Chinese): 丁

Can someone tell me how to select this col into a ProC VARCHAR2
variable? The query in my ProC code returns this a value, but the
lenght is equal to 1. How can I get all the 3 octets into my VARCHAR2
variable?
Does it depends on any compilation option, or the PC locale?

BR,
Helge Hauan


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.