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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: National characters

RE: National characters

From: Weaver, Walt <wweaver_at_rightnow.com>
Date: Mon, 27 Nov 2000 09:58:01 -0700
Message-Id: <10693.122966@fatcity.com> 





This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.



------_=_NextPart_001_01C05893.3385AFD0


Content-Type: text/plain;


        charset="iso-8859-1"



Hi Andrey,
 


We're running UTF8 on an 8.1.6 database, using CLOB's and varchar2 to store
English, Portuguese, Spanish, German, and (in test, anyway) Japanese stuff.
 


The only problem I had was when I migrated the data initially from an 8.0.5
database running WE8ISO8859P1 to the UTF8 database. I pre-created all of the
tables and indexes, and during the data migration got a number of "inserted
value too large for column" messages. Didn't have any problems with the LOB
columns, but I had to create the varchar2 columns twice the size they used
to be, since UTF8 uses double the space for accented characters and such. 
 


Other than that, I really haven't had any problems or done anything special.
Just remember that LOB support wasn't available until Oracle 8i, so if
you're going to use UTF8, you won't be able to use any earlier versions of
Oracle...
 


HTH,



--Walt Weaver


  Bozeman, Montana, USA
 


 -----Original Message-----


From: Andrey Bronfin [mailto:bronfin_at_VisualTop.com]
Sent: Monday, November 27, 2000 8:46 AM


To: ORACLE-L_at_lists.sunysb.edu; ORACLE-L_at_fatcity.com;
oracledba_at_quickdoc.co.uk


Subject: National characters 





Dear Gurus !
 


It appears that i need to design , build and support a database that will
support DATA in different languages with different character sets (
including such "exotic" languages as Chinese , Hindi , Arabic , Russian ,
Hungarian and all the European languages ) .
The texts in those languages should be stored in Varchar and LOB columns .
I need to support all those various character sets in ONE DB . I don't need
to manipulate it , just to be able to retrieve the text as it was stored (
typed in ) .
 


I have no experience with DB character sets other than English , therefore
i'd like to ask those of U who has such experience to help me .
Please tell me whether this can be done and how .
Where can i read about it ( docs , URLs , etc ... )  ?
What should i be aware of ?


Are there any limitations ?
 


Thanks a lot in advance .



Andrey Bronfin

 

 




------_=_NextPart_001_01C05893.3385AFD0


Content-Type: text/html;


        charset="iso-8859-1"



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD>

<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">





<META content="MSHTML 5.00.2920.0" name=GENERATOR>

<STYLE></STYLE>

</HEAD>

<BODY bgColor=#dfdcd7>

<DIV>

<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=922554716-27112000>Hi 

Andrey,</SPAN></FONT></DIV>


<DIV><SPAN class=922554716-27112000></SPAN><FONT color=#0000ff face=Arial 

size=2>&nbsp;</FONT></DIV>


<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=922554716-27112000>We're 

running UTF8 on an 8.1.6 database, using CLOB's and varchar2 to store English, 
Portuguese, Spanish, German, and (in test, anyway) Japanese 
stuff.</SPAN></FONT></DIV>


<DIV><SPAN class=922554716-27112000></SPAN><FONT color=#0000ff face=Arial 

size=2>&nbsp;</FONT></DIV>


<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=922554716-27112000>The 

only problem I had was when I migrated the data initially from an 8.0.5 database 
running WE8ISO8859P1 to the UTF8 database. I pre-created all of the tables and 
indexes, and during the data migration got a number of "inserted value too large 
for column" messages. Didn't have any problems with the LOB columns, but I had 
to create the varchar2 columns twice the size they used to be, since UTF8 uses 
double the space for accented characters and such. </SPAN></FONT></DIV>


<DIV><SPAN class=922554716-27112000></SPAN><FONT color=#0000ff face=Arial 

size=2>&nbsp;</FONT></DIV>


<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=922554716-27112000>Other 

than that, I really haven't had any problems or done anything special. Just 
remember that LOB support wasn't available until Oracle 8i, so if you're going 
to use UTF8, you won't be able to use any earlier versions of 
Oracle...</SPAN></FONT></DIV>


<DIV><SPAN class=922554716-27112000></SPAN><FONT color=#0000ff face=Arial 

size=2>&nbsp;</FONT></DIV>


<DIV><FONT color=#0000ff face=Arial size=2><SPAN 

class=922554716-27112000>HTH,</SPAN></FONT></DIV>


<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN 

class=922554716-27112000>--Walt<SPAN class=624240417-27112000> 
Weaver</SPAN></SPAN></FONT></FONT></FONT></DIV>


<DIV><FONT size=2><FONT color=#0000ff><FONT face=Arial><SPAN 

class=922554716-27112000><SPAN class=624240417-27112000>&nbsp; Bozeman, Montana, 
USA</SPAN></SPAN></FONT></FONT></FONT></DIV>


<DIV><SPAN class=922554716-27112000><SPAN 

class=624240417-27112000></SPAN></SPAN>&nbsp;</DIV>


<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=922554716-27112000><SPAN 

class=624240417-27112000>&nbsp;</SPAN></SPAN></FONT><FONT face=Tahoma><FONT 
size=2>-----Original Message-----<BR><B>From:</B> Andrey Bronfin 
[mailto:bronfin_at_VisualTop.com]<BR><B>Sent:</B> Monday, November 27, 2000 8:46 
AM<BR><B>To:</B> ORACLE-L_at_lists.sunysb.edu; ORACLE-L_at_fatcity.com; 
oracledba_at_quickdoc.co.uk<BR><B>Subject:</B> National characters 


<BR><BR></DIV></FONT></DIV>

<BLOCKQUOTE style="MARGIN-RIGHT: 0px"></FONT>


  <DIV><FONT face=Arial size=2>Dear Gurus !</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>It appears that i need to design , build and 


  support a database that will support DATA in different languages with 
  different character sets ( including such "exotic" languages as Chinese , 
  Hindi , Arabic , Russian , Hungarian and all the European languages ) 
  .</FONT></DIV>


  <DIV><FONT face=Arial size=2>The texts in those languages should be stored in 
  Varchar and LOB columns .</FONT></DIV>
  <DIV><FONT face=Arial size=2>I need to support all those 
  various&nbsp;character sets in&nbsp;ONE DB . I don't need to manipulate it , 
  just to be able to retrieve the text as it was stored ( typed in ) 
  .</FONT></DIV>


  <DIV>&nbsp;</DIV>


  <DIV><FONT face=Arial size=2>I have no experience with DB character sets other 
  than English , therefore i'd like to ask those of U who has such experience to 
  help me .</FONT></DIV>


  <DIV><FONT face=Arial size=2>Please tell me whether this can be done and how 
  .</FONT></DIV>


  <DIV><FONT face=Arial size=2>Where can i read about it ( docs , URLs , etc ... 
  )&nbsp; ?</FONT></DIV>

  <DIV><FONT face=Arial size=2>What should i be aware of ?</FONT></DIV>
  <DIV><FONT face=Arial size=2>Are there any limitations ?</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>Thanks a lot in advance .</FONT></DIV>
  <DIV><FONT face=Arial size=2><BR>Andrey Bronfin<BR></FONT></DIV>
  <DIV>&nbsp;</DIV>


Received on Mon Nov 27 2000 - 10:58:01 CST












Original text of this message













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