Re: Unique or primary key constraint error while BULK import back into table after BULK export

[Bryan Pendleton]

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