The following post was unfortunately waylaid
and did not make it to the list. I forward
for your attention.
Regards,
-- Sarasvati
> From: Samir Mehrotra <samirmehrotra@mailcity.com>
> Date: Wed, 08 Mar 2000 10:22:00 +0530
Hi,
I am Samir Mehrotra, working on the project to Internationalize our existing software, in this regard i anticipate your help. I am already a subscriber of the mailing list and thus getting very useful information every day.
We want to support multi byte character sets to the already developed software which was developed using English. now we want to support Japanese,Koean,Chinese etc.
My question are (The Fifth question is very important for me):
1. What issues are involved in such a project?
2. How to set NLS parameters in Oracle 8.0.5, I have done this through Oracle Enterprise Manager(GUI Based) during installation, i have just selcted a particular language, will it work?
3. Do we really require NCHAr and NVARCHAR2 datatypes, will CHAR/VARCHAR2 won't suffice?
4. If we do have to select NCHAR/NVARCHAR2 then what is the sequence of doing/setting this, since i was trying to assign a string to NCHAR, an error of character set was given by the system.
5. If we chose UTF-8, then do we have to change the column width to say 40 (for a double byte character set e.g., Korean) if it was earlier defined to be at 20(while using a Single Byte character set e.g. English). How should i chose to set the column widths if i want to support Fixed Width Character sets and Variable width character sets (as it has been written in one of the documents that the column widths are measured in "characters" for a fixed width character set and "Bytes" while using a Variable width character set.....I want my database capable to handle both types of the character sets.
6. Do we have to change the column width(having CHAR/VARCHAR DATATYPE) to say 40 (for a double byte character set e.g., Korean) if it was earlier defined to be at 20(while using a Single Byte character set e.g. English). How should i chose to set the column widths if i want to support Fixed Width Character sets and Variable width character sets (as it has been written in one of the documents that the column widths are measured in "characters" for a fixed width character set and "Bytes" while using a Variable width character set.....I want my database capable to handle both types of the character sets.
Thanks in advance
Samir Mehrotra
samirmehrotra@mailcity.com
Bombay - India.
This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:20:59 EDT