OracleServer schreef:
> 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
>
If Pro*C, your varchar2 would be the Oracle varchar2.
In that case, you'll need Nvarchar2; and you also
want to define it as nvarchar2(30 char), if your name
would consist of 30 characters
If C - I'm long done with that, V5 of MSC is the last
I ever worked with - sorry.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Apr 18 2007 - 13:27:54 CDT
