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: Laurenz Albe <invite_at_spam.to.invalid>
Date: 07 May 2007 08:35:42 GMT
Message-ID: <1178526940.352766@proxy.dienste.wien.at>


OracleServer <helge.hauan_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 Received on Mon May 07 2007 - 03:35:42 CDT

Original text of this message

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