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].
thanks,
Addison
Addison P. Phillips
Senior Globalization Consultant
Global Sight Corporation
mailto:addison@globalsight.com
================================
101 Metro Drive, Suite 750
San Jose, California 95110 USA
(+1) 408.350.3649 - Phone
http://www.globalsight.com
================================
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" <unicode@unicode.org>
cc: Unicode List <unicode@unicode.org>
bcc:
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
table.
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,
Parvinder
This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:02 EDT