Re: Help ... NVarchar2 Question

I would say do a search on NVARCHAR2 and unicode at this NG or the ORACLE Metallink. It is a big topic, so you can not catch all the issues with one shot.
Go slow. Read and test, read and test. And I mean test with real multi-lingual data. Only by testing with real multi-byte characters data will you be able to identify problems early. For example, with UTF8, you may have to triple the size a varchar2 column to accomodade non-English characters. As these characters can range from 1 to 3 bytes, but then you have to consider the size limit of a varchar2 or char. To process the data properly in a stored procedure, you may also have to triple the size of the variables in PL/SQL.

• Jusung Yang

"Rob Panosh" <rob_panosh_at_asdsoftware.com> wrote in message news:<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 - 20:15:49 CEST