db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Unique or primary key constraint error while BULK import back into table after BULK export
Date Fri, 07 May 2010 13:29:04 GMT
> create table chartestme(name CHAR(50) not null);
> insert into chartestme values ('HELLO') ;
> insert into chartestme values ('HELLO  ') ;

I believe that Derby considers both those values as being padded
with spaces to make them each exactly 50 characters long:
http://db.apache.org/derby/docs/10.5/ref/rrefsqlj13733.html

thanks,

bryan

Mime
View raw message