db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vadim Gritsenko <va...@reverycodes.com>
Subject I18n and Oracle9
Date Wed, 30 Mar 2005 18:29:13 GMT
Hi All,

As you might know, in default Oracle install,

     VALUE VARCHAR(20)

actually means 20 *bytes*, not 20 characters. So for i18n applications this 
means that actual limit is closer to 10 or less characters - depending on 
encoding. Since Oracle9 it's possible to specify that when you create a 
character field of specified length you actually *do* mean that this length is 
in characters, not bytes! New syntax is:

     VALUE VARCHAR(20 CHAR)

Alternatively, one can use NVARCHAR, which is (AFAIU) will always use UTF-16 
encoding and length is always in characters, not bytes.

Questions,

   * Is there a way to instruct torque to create schema using above syntax?

   * Is there a way to instruct torque to use nvarchar instead of varchar?

   * Should OJB default to creating schema with length in characters instead
     of creating schema with length in bytes?

Thanks,
Vadim


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message