Re: Intenational character sets

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:qm2lv0t39euk9p1soj7032o3i2fl7g6d3j_at_4ax.com...
> Oracle EE 9.2 on Solaris

-snip-
> In case anyone here speaks Websphere, or EJB, here is what appears to
> be the core of their problem:
>
> ===============
> OMS does not have the database issue when the CHAR fields in the
> database use a BYTE semantic. This is what was set when we developed
> OMS. However, the CHAR fields were changed to use a CHAR semantic
> since french characters use more then one byte. When this was changed
> to the CHAR semantic, that is when the issue arised.
-snip-

It appears that nls_length_semantics is being referred to out here. This setting applies to multi-byte charactersets (AL32UTF8 ... etc) wherein you specify the length of the column in characters.

However, one would expect problem to appear when byte semantics is set and not when char semantics is set.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch2.htm#104339 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch1121.htm#1020017

Sybrand's comment makes more sense though. The application might be using ucs2 (two byte) and is treating oracle column lengths as chars. A possible solution might be to use unicode with nls_length_semantics .. if supporting multiple languages....

Anurag Received on Fri Jan 28 2005 - 23:02:25 CST