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?
> 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.

View raw message