db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject Re: Trailing space in VARCHARs
Date Sun, 05 Aug 2007 21:27:49 GMT
Andrew ``Bass'' Shcheglov wrote:
>
> If I have a table with a VARCHAR field
> with a UNIQUE constraint placed on that field,
> I can't insert two records that differ only in trailing space,
> say 'foo' and 'foo '.
> I have 2 questions:
>
> 1. Is the described above a legitimate behaviour of Derby?
>
Seems to be the documented behavior
http://db.apache.org/derby/docs/10.2/ref/rrefsqlj41207.html

> 2. Can I somehow turn this behaviour off
> (for Derby to behave more like Oracle)?
>
I don't know

Kathey



Mime
View raw message