| 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: Character sets
This is a multi-part message in MIME format.
------=_NextPart_000_001D_01BFBFD2.FED87820 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
There's a pretty good discussion of charactersets in the Oracle manuals and in documents found on Metalink. They'll probably provide the information you're looking for.
CLOB support for multi-byte variable-width charactersets like UTF8 is available as of Oracle 8.1.5.
HTH,
--Walt Weaver
Bozeman, Montana, USA
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of David Turner
Sent: Tuesday, May 16, 2000 4:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Character sets
I really don't have a good grasp of character sets and am reading through the Oracle manual and still don't know which character set would be good for our international databases. One of our DBAs had suggested a character set of utf8, but I don't know why this would be better than one over another. Anyone know the most widely used character set aside from the default? One other thing. It looks like utf8 doesn't support clobs which I need. I need a character set that supports basically all the datatypes.
Thanks, Dave Turner
-- Dave Turner, Senior Database Administrator, Linuxcare, Inc. 913.383.3052 tel, 913.579.3803 cel, 877.443.9553 pager dturner@linuxcare.com, http://www.linuxcare.com/ Linuxcare. Support for the revolution. -- ------=_NextPart_000_001D_01BFBFD2.FED87820 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Wed May 17 2000 - 08:39:11 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D730373513-17052000>There's a pretty good discussion of = charactersets in=20 the Oracle manuals and in documents found on Metalink. They'll probably = provide=20 the information you're looking for.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D730373513-17052000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D730373513-17052000>CLOB=20 support for multi-byte variable-width charactersets like UTF8 is = available as of=20 Oracle 8.1.5.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D730373513-17052000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D730373513-17052000>HTH,</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D730373513-17052000>--Walt=20 Weaver</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D730373513-17052000> =20 Bozeman, Montana, USA</SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20 size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20 [mailto:root_at_fatcity.com]<B>On Behalf Of </B>David = Turner<BR><B>Sent:</B>=20 Tuesday, May 16, 2000 4:05 PM<BR><B>To:</B> Multiple recipients of = list=20 ORACLE-L<BR><B>Subject:</B> Character sets<BR><BR></DIV></FONT>I = really don't=20 have a good grasp of character sets and am reading through the Oracle = manual=20 and still don't know which character set would be good for our = international=20 databases. One of our DBAs had suggested a character set of utf8, but = I don't=20 know why this would be better than one over another. Anyone know the = most=20 widely used character set aside from the default?=20 <P>One other thing. It looks like utf8 doesn't support clobs which I = need. I=20 need a character set that supports basically all the datatypes.=20 =
<P> &nbs=
p;  = ; = &= nbsp; &n= bsp; &nb= sp; =20 Thanks, Dave Turner <PRE>-- Dave Turner, Senior Database Administrator, Linuxcare, Inc. 913.383.3052 tel, 913.579.3803 cel, 877.443.9553 pager dturner_at_linuxcare.com, <A = href=3D"http://www.linuxcare.com/">http://www.linuxcare.com/</A> Linuxcare. Support for the revolution.
 |
 |