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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
