Parvinder,
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.
- Michael
addison@globalsight.com wrote:
> 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