db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: Characters and bytes
Date Tue, 19 Jun 2007 17:53:06 GMT
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.


Mime
View raw message