Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Select UNICODE (UTF8) data as octets from database

Select UNICODE (UTF8) data as octets from database

From: OracleServer <helge.hauan_at_applica.no>
Date: 18 Apr 2007 00:49:54 -0700
Message-ID: <1176882594.651754.145770@b75g2000hsg.googlegroups.com>


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 Received on Wed Apr 18 2007 - 02:49:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US