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
