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)" <P.Singh@ehpt.com>
04/20/2000 04:12 AM
To: "Unicode List" <email@example.com>
cc: Unicode List <firstname.lastname@example.org>
Subject: Swedish data in Oracle table
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
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