Message-Id: <10501.105983@fatcity.com> From: David Turner Date: Thu, 18 May 2000 08:54:26 -0700 Subject: Re: Character sets --------------21BCBEAA38BA1850166889A1 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The example I gave was just a test to see if the database would allow me to create a table with a CLOB. Here's my create database script create database db1sjp01 controlfile reuse maxlogfiles 50 character set utf8 datafile....................... I set it back to the default character set and the error went away. I guess I have some reading to do. Dave Turner Andreas Jung wrote: > On Wed, May 17, 2000 at 04:28:13PM -0800, David Turner wrote: > > 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 > > Our NLS_LANG is set to ".UTF8". Your NLS_LANG is also not valid ! > For using Intermedia for fulltext indexing your table also needs a (unique) > primary key. Did you really set up your database with UTF8 ? > > Andreas > -- > Author: Andreas Jung > INET: ajung@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@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. -- --------------21BCBEAA38BA1850166889A1 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit The example I gave was just a test to see if the database would allow me to create a table with a CLOB. Here's my create database script

create database db1sjp01
    controlfile reuse
    maxlogfiles 50
   character set utf8
    datafile.......................

I set it back to the default character set and the error went away. I guess I have some reading to do.

Dave Turner

Andreas Jung wrote:

On Wed, May 17, 2000 at 04:28:13PM -0800, David Turner wrote:
> 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
Our NLS_LANG is set to ".UTF8". Your NLS_LANG is also not valid !
For using Intermedia for fulltext indexing your table also needs a (unique)
primary key. Did you really set up your database with UTF8 ?
Andreas
--
Author: Andreas Jung
INET: ajung@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@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/