Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem in UTF8 migration from monolingual characterset
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