Hi Francois, Do you see Cayenne doing this (look at the logs -- such as the bind: messages to see if the string is trimmed at that point) or is it the JDBC driver or a database setting? Many databases will trim trailing spaces, but should leave leading space alone unless there is a configuration that changes it.
mrg On Fri, Jan 14, 2011 at 11:56 AM, Francois Eyl <[email protected]> wrote: > Hi guys, > > I've been using cayenne in several projects on top of MS SQL Sever, and It > just makes the job easier. > > I'm playing now with it against a DB2 database (embeded in AS400/i5/IBM > System i) using the JT400 JDBC Driver. I'm facing to a strange behavior. It > looks like cayenne trim the left of my property's value to remove space > characters in case of the db field is a CHAR. > > If I run the same sql select query out of cayenne, the value isn't trim. > > Is there any settings to turn off/on or something to avoid this with > cayenne? Is this a bug, if so, do I need to file a bug? > > Thanks for your help, > Francois >
