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: Problem in UTF8 migration from monolingual characterset

Re: Problem in UTF8 migration from monolingual characterset

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 14 Feb 2006 20:27:51 +0100
Message-ID: <dsta8h$ld4$1@news4.zwoll1.ov.home.nl>


adik_q_at_wp.pl wrote:
> You have to increase appropriate column size, in the worst case to
> double of size before conversion.
>
> Regards,
> Adrian
>

Or (re)create them with character semantics, as opposed to the (default) byte semantics:

SQL> create table blah (
  2 col1 varchar2(20 char));
Table created.

SQL> desc blah

 Name                            Null?    Type
 ------------------------------- -------- ------------------
 COL1                                     VARCHAR2(20 CHAR)

SQL> drop table blah ;
Table dropped.

SQL> create table blah (
  2 col1 varchar2(30 byte));
Table created.

SQL> desc blah

 Name                             Null?    Type
 -------------------------------- -------- --------------
 COL1                                       VARCHAR2(30)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Tue Feb 14 2006 - 13:27:51 CST

Original text of this message

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