Williamson, Nick wrote:
> Hi all,
>
> In Oracle, you can specify character columns widths in bytes (the
> default) or characters. The advantage of specifying column width in
> characters is that you can attempt to store - say - 10 multi-byte
> characters in a VARCHAR(10) column without getting an error.
>
> Derby doesn't seem to have an equivalent clause in the CREATE TABLE
> statement. What does it default to, and can the default be overridden?
>
> TIA
> Nick
>
>
Hi -
Derby's varchar(10) will store 10 Unicode (multi-byte) characters. Are
you saying you are getting an error when you attempt to do this? I
don't see an advantage to specifying bytes when all Derby data is stored
in a modified Unicode format.
|