Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Character sets

Re: Character sets

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Thu, 18 May 2000 07:29:00 +0200
Message-Id: <10500.105918@fatcity.com>


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 ? Received on Thu May 18 2000 - 00:29:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US