| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: National characters
This is a multi-part message in MIME format.
------=_NextPart_000_008D_01C058A6.383A1580 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Walt !
Glad to see U not driving a bus yet :)=20
Seriously , many thanks for your reply .
Just another question :
how do U insert the foreign language stuff into the DB ?=20
Is it typed in by users that have National characters on their keyboards =
or is it loaded from files ?
How do U see that all the data is OK ?
TIA . P.S : I'm using 8.1.6=20
Hi Andrey,
=20
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.
=20
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.=20
=20
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...
=20
HTH,
--Walt Weaver
Bozeman, Montana, USA
=20
-----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=20
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
=20
------=_NextPart_000_008D_01C058A6.383A1580 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" =http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#dfdcd7> <DIV><FONT face=3DArial size=3D2>Hi Walt !</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Glad to see U not driving a bus yet :)=20 </FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Seriously , many thanks for your reply=20.</FONT></DIV>
<DIV> </DIV> <DIV><FONT face=3DArial size=3D2>TIA .</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>P.S : I'm using 8.1.6 </FONT></DIV> <DIV> </DIV> <BLOCKQUOTE=20
<DIV><BR></DIV> <DIV> <DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =class=3D922554716-27112000>Hi=20
</SPAN></FONT></DIV>
<DIV><SPAN class=3D922554716-27112000></SPAN><FONT color=3D#0000ff =
face=3DArial=20
size=3D2> </FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D922554716-27112000>Other than that, I really haven't had any =
problems or=20
done anything special. Just remember that LOB support wasn't available =
until=20
Oracle 8i, so if you're going to use UTF8, you won't be able to use =
any=20
earlier versions of Oracle...</SPAN></FONT></DIV>
<DIV><SPAN class=3D922554716-27112000></SPAN><FONT color=3D#0000ff =
face=3DArial=20
size=3D2> </FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D922554716-27112000>HTH,</SPAN></FONT></DIV>
<DIV><FONT size=3D2><FONT color=3D#0000ff><FONT face=3DArial><SPAN=20
class=3D922554716-27112000>--Walt<SPAN class=3D624240417-27112000>=20
Weaver</SPAN></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT size=3D2><FONT color=3D#0000ff><FONT face=3DArial><SPAN=20
class=3D922554716-27112000><SPAN class=3D624240417-27112000> =
Bozeman,=20
Montana, USA</SPAN></SPAN></FONT></FONT></FONT></DIV>
<DIV><SPAN class=3D922554716-27112000><SPAN=20
class=3D624240417-27112000></SPAN></SPAN> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D922554716-27112000><SPAN=20
class=3D624240417-27112000> </SPAN></SPAN></FONT><FONT =
face=3DTahoma><FONT=20
size=3D2>-----Original Message-----<BR><B>From:</B> Andrey Bronfin=20
[mailto:bronfin_at_VisualTop.com]<BR><B>Sent:</B> Monday, November 27, =
2000 8:46=20
AM<BR><B>To:</B> ORACLE-L_at_lists.sunysb.edu; ORACLE-L_at_fatcity.com;=20
oracledba_at_quickdoc.co.uk<BR><B>Subject:</B> National characters=20
<BR><BR></DIV></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"></FONT>
<DIV><FONT face=3DArial size=3D2>Dear Gurus !</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>It appears that i need to design , =
build and=20
support a database that will support DATA in different languages = with=20
different character sets ( including such "exotic" languages as = Chinese ,=20
Hindi , Arabic , Russian , Hungarian and all the European languages = )=20
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>The texts in those languages should =
be stored=20
in Varchar and LOB columns .</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I need to support all those=20 various character sets in ONE DB . I don't need to = manipulate it ,=20
just to be able to retrieve the text as it was stored ( typed in )=20
.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I have no experience with DB =
character sets=20
other than English , therefore i'd like to ask those of U who has = such=20
experience to help me .</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Please tell me whether this can be = done and how=20
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Where can i read about it ( docs , =
URLs , etc=20
... ) ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>What should i be aware of =
?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Are there any limitations = ?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks a lot in advance =
.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2><BR>Andrey Bronfin<BR></FONT></DIV> Received on Mon Nov 27 2000 - 11:14:09 CST
 |
 |