Re: Help ... NVarchar2 Question

From: Rob Panosh <rob_panosh_at_asdsoftware.com>
Date: Wed, 16 Oct 2002 07:09:43 -0500
Message-ID: <3dad6572$1_at_news.splitrock.net>


Jusang Yang,

Thank you for you response. I would love to read up on this. Do you have any suggestions on white papers, web sites, etc. ...

Thanks,
Rob Panosh

"Jusung Yang" <JusungYang_at_yahoo.com> wrote in message news:130ba93a.0210152209.6cee0595_at_posting.google.com...
> The quick answer is yes. Though if your database character set is of
> unicode, such as UTF8, you don't really need NVARCHAR2 or NCHAR to
> store unicode characters. I would recommend looking at the whole
> picture of your application and decide what to go with. How to get the
> multi-language data into the database, how to store it, how to process
> it, what data types and precision you are going to use in your stored
> procedures, how to present it to the users, are there going to be
> problems with differnet linguestic version of the OS. It is very, very
> complex. Column data type is just a small piece of it. In many
> companies internationalization of a product is the sole focus of a
> whole group or deparment. Typically they work with the core developers
> and DBA on the design and testing. So, basically, think global and
> read more on the multi-language issues.
>
>
> - Jusung Yang
>
>
> "Rob Panosh" <rob_panosh_at_asdsoftware.com> wrote in message
 news:<3dac8260$1_at_news.splitrock.net>...
> > I have the following table:
> >
> > Create Table myTest ( fmTestColumn NVARCHAR2(20) )
> >
> > Does the NVARCHAR2 designate this columns as a character column that can
> > store UNICODE characters? If not how should I define my columns
 VARCHAR2?
> > I am developing an application with many tables and I want to make sure
 I
> > have my table definintions correct.
> >
> > Thanks,
> > Rob Panosh
> > Advanced Software Designs
Received on Wed Oct 16 2002 - 14:09:43 CEST

Original text of this message