Re: Character sets

From: David Turner <dturner_at_linuxcare.com>
Date: Wed, 17 May 2000 15:14:04 -0700
Message-Id: <10500.105905@fatcity.com>

--------------45ACB4C210D27AF666E6828A
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

That's really odd. I set up a database with UTF8 and kept getting the error message

create table dude(id clob)

ORA-22866: default character set is of varying width

I am running Oracle 8.1.5.0.2 on Linux. My NLS_LANG = AMERICA_AMERICA.UTF8

Thanks for the help, Dave Turner

Andreas Jung wrote:

> On Tue, May 16, 2000 at 02:05:04PM -0800, David Turner wrote:
> > 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.
> >
> UTF8 usually should fit your need. We store XML document (UTF8)
> in CLOBS. Fulltext indexing with Intermedia works perfectly.
>
> That's your choice,
> Andreas
> --
> Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
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.
--



--------------45ACB4C210D27AF666E6828A
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
That's really odd. I set up a database with UTF8 and kept getting the error
message
<p>create table dude(id clob)
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
*
<br>ORA-22866: default character set is of varying width
<p>I am running Oracle 8.1.5.0.2 on Linux. My NLS_LANG&nbsp;= AMERICA_AMERICA.UTF8
<br>&nbsp;
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Thanks for the help, Dave Turner
<p>Andreas Jung wrote:
<blockquote TYPE=CITE>On Tue, May 16, 2000 at 02:05:04PM -0800, David Turner
wrote:
<br>> I really don't have a good grasp of character sets and am reading
<br>> through the Oracle manual and still don't know which character set
would
<br>> be good for our international databases. One of our DBAs had suggested
a
<br>> character set of utf8, but I don't know why this would be better
than
<br>> one over another. Anyone know the most widely used character set
aside
<br>> from the default?
<br>>
<br>> One other thing. It looks like utf8 doesn't support clobs which I
need.
<br>> I need a character set that supports basically all the datatypes.
<br>>
<br>UTF8 usually should fit your need. We store XML document (UTF8)
<br>in CLOBS. Fulltext indexing with Intermedia works perfectly.
<p>That's your choice,
<br>Andreas
<br>--
<br>Author: Andreas Jung
<br>&nbsp; INET: ajung_at_sz-sb.de
<p>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;
FAX: (858) 538-5051
<br>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --
Public Internet access / Mailing Lists
<br>--------------------------------------------------------------------
<br>To REMOVE yourself from this mailing list, send an E-Mail message
<br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
<br>the message BODY, include a line containing: UNSUB ORACLE-L
<br>(or the name of mailing list you want to be removed from).&nbsp; You
may
<br>also send the HELP command for other information (like subscribing).</blockquote>

<pre>--
Dave Turner, Senior Database Administrator, Linuxcare, Inc.
913.383.3052 tel, 913.579.3803 cel, 877.443.9553 pager&nbsp;
dturner@linuxcare.com, <A HREF="http://www.linuxcare.com/">http://www.linuxcare.com/</A>

Received on Wed May 17 2000 - 17:14:04 CDT