On 18 Apr, 20:27, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> 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...– Skjul sitert tekst –
>
> – Vis sitert tekst –
Hi again.
Since this is an already existing database and we are migrating to
Traditional Chinese the existing column has previously defined as
VARCHAR2, not NVARCHAR2. According to Oracle guide I should select the
column into a utext variable (unsigned short), but this is not what I
want to do, because it seems that this variable is ment to be used for
UTF16, and not UTF8.
Received on Fri May 04 2007 - 15:33:57 CDT
