Sarasvati,
I try to answer your question as below. If you have more questions, please send me directly.
Regards,
Jianping.
Sarasvati wrote:
> 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?
You need to handle language convention, locale message, and string manipulation. It will be a very long word to explain it, but you can pick up a book such as CJKV Information Processing by Ken Lunde.
>
>
> 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?
>
You need to create your database with character set 'UTF8'. For client side NLS setting, you can use native encoding for Chinese, Korean, or Japanese, or UTF8, based on your client OS support. For more detail description, please refer to the Oracle 8i National Language Support Guide under the database at Oracle home page http://www.oracle.com.
>
> 3. Do we really require NCHAr and NVARCHAR2 datatypes, will CHAR/VARCHAR2 won't suffice?
>
You don't need to use NCHAR or NVARCHAR. CHAR/VARCHAR2 will 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.
you need to assign a NCHAR string as N' ' to a NCHAR.
>
>
> 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.
>
You should choose the size that can accommodate the largest width. For the UTF8 case, you should choose the byte size as three times the character size.
> 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.
>
Yes, you have to do that.
>
> 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