Re: Swedish data in Oracle table

From: Michael Yau (myau@us.oracle.com)
Date: Thu Apr 20 2000 - 12:48:38 EDT


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