This and the previous reply are correct. Is there any particular reason
you want to use NVARCHAR? Oracle supports Unicode (UTF8) in the regular
VARCHAR types. You can send me e-mail directly if you have any further
questions about Oracle.
> 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
> 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
> 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
> I set NLS_LANG = Swedish_Sweden.WE8ISO8859P1 before going to SQL
> 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