Re: Character sets

From: David Turner <dturner_at_linuxcare.com>
Date: Thu, 18 May 2000 08:54:26 -0700
Message-Id: <10501.105983@fatcity.com>

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



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

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
The example&nbsp; I gave was just a test to see if the database would allow
me to create a table with a CLOB.&nbsp; Here's my create database script
<p>create database db1sjp01
<br>&nbsp;&nbsp;&nbsp; controlfile reuse
<br>&nbsp;&nbsp;&nbsp; maxlogfiles&nbsp; 50
<br>&nbsp;&nbsp; character set utf8
<br>&nbsp;&nbsp;&nbsp; datafile.......................
<p>I set it back to the default character set and the error went away.
I guess I have some reading to do.
<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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Dave Turner
<p>Andreas Jung wrote:
<blockquote TYPE=CITE>On Wed, May 17, 2000 at 04:28:13PM -0800, David Turner
wrote:
<br>> That's really odd. I set up a database with UTF8 and kept getting
the error
<br>> message
<br>>
<br>> create table dude(id clob)
<br>>&nbsp;&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
<br>>
<br>> I am running Oracle 8.1.5.0.2 on Linux. My NLS_LANG = AMERICA_AMERICA.UTF8
<p>Our NLS_LANG is set to ".UTF8".&nbsp; Your NLS_LANG is also not valid
!
<br>For using Intermedia for fulltext indexing your table also needs a
(unique)
<br>primary key. Did you really set up your database with UTF8 ?
<p>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 Thu May 18 2000 - 10:54:26 CDT