Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get UTF8 character array in Pro*C from a VARCHAR2 column from the database with character set equals AL32UTF8?
On May 7, 10:35 am, Laurenz Albe <inv..._at_spam.to.invalid> wrote:
> OracleServer <helge.ha..._at_applica.no> wrote:
> > - Oracle 10g Server
> > - Database character set is AL32UTF8
>
> > In the database there is a table <equipm> with the column <nameOfuser>
> > VARCHAR2(20).
>
> > In order to support multibyte character encoding in the existing
> > database the VARCHAR2 column has been extended to VARCHAR2(60).
>
> This is wrong, it should have been VARCHAR2(20 CHAR).
>
> > Does anybody have some other (hopefully better) proposal than look
> > into the Oracle Database Globalization Support Guide? From my point of
> > view this guide contains several faults.
>
> Too complicated?
>
> Yours,
> Laurenz Albe
Hi again.
I've solved the problem by adding functionality for convertion from
wide character string to byte octet string. For some reason Oracle
supports UTF8 in Pro*C via wide character string.
Received on Tue May 08 2007 - 10:19:53 CDT
![]() |
![]() |