Laurenz Albe wrote:
> Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:
>>> The CHAR option is the default so
>>> most just use VARCHAR2(100).
>> NO - Byte is default, CHAR must be specified!
>
> If you do not change the configuration parameters, BYTE is indeed default.
> If you set NLS_LENGTH_SEMANTICS=CHAR, then CHAR will be default (after the
> next instance restart because of Bug 1488174).
>
> Yours,
> Laurenz Albe
Ah - I've been bitten by 1488174, then, and never noticed it.
Since then, made it a habit to use BYTE/CHAR in a MB environment.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Wed Apr 19 2006 - 12:42:10 CDT
