Title: International Language Support Experiences?
we have been using utf8 char set for international
support in the database .
-ak
- Original Message -
From:
David Wagoner
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, August 27, 2003 11:34
AM
Title: Message
David,
I can
share this from an Oracle Apps perspective - we upgraded to UTF8 (a multi byte
char set) from WE8ISO5599-1 (single byte Western Eur charset). Some of the
biggest problems that we faced are:
1.
Cut-and-paste produces incorrect characters which were acceptable in
For clients that do not support UTF8, you can set NLS_LANG on the client
server to the appropriate single byte character set. The Oracle client
library will do the conversion to/from UTF8 when you store/retrieve data
to/from the Oracle server.
In fact, using UTF8 on the Oracle server does not
The main problem I ran into was the fact that we were already supporting a
non-supported set of language characters, and nobody told us of the
requirement! Made the conversion interesting.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/27/2003 1:34 PM
We have a
IIRC, you can't store LOBs in UTF8 since it's a variable width charset?
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 11:59 PM
For clients that do not support UTF8, you can set NLS_LANG on the client
server to
Then you would use NLOB's, IIRC.
Tanel Poder [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/27/2003 02:54 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: International Language Support Experiences
Tanel,
You are correct except it is supported with 8i, make sure compatible parameter is set
to 8.1.x.
-Original Message-
Sent: Wednesday, August 27, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L
IIRC, you can't store LOBs in UTF8 since it's a variable width charset?
Tanel.
Great, in this case I wasn't thinking with my ass, I just remembered this
issue from ancient times :)
Tanel.
You are correct except it is supported with 8i, make sure compatible
parameter is set to 8.1.x.
-Original Message-
Sent: Wednesday, August 27, 2003 5:55 PM
To: Multiple