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

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?

Re: How to get UTF8 character array in Pro*C from a VARCHAR2 column from the database with character set equals AL32UTF8?

From: OracleServer <helge.hauan_at_applica.no>
Date: 8 May 2007 08:19:53 -0700
Message-ID: <1178637593.069681.228990@q75g2000hsh.googlegroups.com>


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

Original text of this message

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