Re: Swedish data in Oracle table

Date: Thu Apr 20 2000 - 12:10:18 EDT

Hi Parvinder,

Why not use a varchar(100) instead?

Oracle will translate WE8ISO8859P1 to UTF8 (and back again) for you nicely. There is no reason to use the nchar types as far as I can tell from your description [nchar types exist to allow you to store characters in a different encoding from that of the database in that *other* encoding--what you want to do is store Unicode and let Oracle take care of the conversion].



Addison P. Phillips
Senior Globalization Consultant
Global Sight Corporation
101 Metro Drive, Suite 750
San Jose, California 95110 USA
(+1) 408.350.3649 - Phone

Going global with your web site? Global Sight provides Web-based
software solutions that simplify the process, cut costs, and save time.

Sent by: "Parvinder Singh(EHPT)" <>
04/20/2000 04:12 AM

To: "Unicode List" <>
cc: Unicode List <>
Subject: Swedish data in Oracle table

Hello everybody,
I am new to the unicode world and unicode mailing list.

Can anybody give a simple insert statement to insert a
data into a column of datatype nvarchar2(100) of a

The database character set defined in the create
database command is UTF8(Unicode character set)

My aim is that if col1 is nvarchar2(100),then how
should I insert  some Swedish characters  "äääääää"  in
this column.
I tried with this :
SQL> insert into table1(col1) values(Swedish characters in single quote);

I set NLS_LANG = Swedish_Sweden.WE8ISO8859P1 before going to SQL prompt.
Is it OK ?
Also is National Charcter Set need to be defined to accomplish the above task?
If yes,How ?

Thanks and Rgds,

This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:02 EDT