Re: Help ... NVarchar2 Question

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 - 08:09:15 CEST