Sebastian Niezgoda wrote:
Hello,
I noticed that Derby does not trim any excess space on SELECT
statements. I'm using iBatis to map sql to Java objects thus I am
forced to change my queries to trim. Is there an easier way to do
this? Is there a global setting I can use when creating/connecting to
Derby or something along those lines?
Thanks,
Sebastian
Hi -
I'm guessing you mean 'does not trim trailing space from the data values
returned'. Derby should do this for VARCHAR fields but doesn't for
fixed length datatypes. What datatypes are you retrieving and are you
performing conversions or concatenations in your select statements?
