Re: Forwarding some questions

From: Linus Toshihiro Tanaka (
Date: Wed Mar 08 2000 - 19:18:07 EST


> 1. What issues are involved in such a project?

The most important thing is for developers to know that one codepoint
could be one, two, three, or four bytes (or maybe more in some systems).

> 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?

I recommend for you to check Oracle8i National Language Support Guide
(URL shown below). Although this manual is for Oracle8i, most of the
features exist in Oracle8 also.

> 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.

Most likely, what you are trying to do doesn't require NCHAR/NVARCHAR2
in Oracle8/Oracle8i.

> 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).

Since Korean characters cannot be represented in single-byte character
set, it's not correct to say "Korean takes double space as English".
The correct way is, if the original contents are English, we need to
come up with the number of Korean characters to express the same meaning
as English, then multiply it by 3 if you are using UTF-8 (because one
Korean Hangul character takes 3 bytes in UTF-8). If 10 Korean Hangul
characters can express the same meaning as 20 English characters, you
need 30 bytes for this column. Please note that the situation really
varies. For example, if you are storing people's full names, they are
often longer in Spanish than English. The difference between English
and Spanish could possibly be bigger than the difference between English
and Korean.

Best Regards,
| Linus Toshihiro Tanaka 500 Oracle Parkway M/S 4op7 |
| NLS Consulting Team Redwood Shores, CA 94065 USA |
| Server Globalization Technology email: |
| Oracle Corporation |

This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:20:59 EDT