[castor-dev] Trailing spaces for strings retrieved in Dblocked mode are truncated

[vishal.madan]

Hi,   I have a database table with a field of type CHAR(6). The DB (MySQL) allows me to store strings with trailing spaces. When I try and retrieve from the database using Castor where my query is based on the contents of the string, the trailing spaces get truncated if I execute the query in DbLocked mode. But, the same query in ReadOnly mode will return the string properly with the trailing spaces.   Example OQL query: SELECT system FROM mytest.System system WHERE System.number = $1 AND System.name IN LIST ( "VI01  ")   When this query is executed in the DBLocked mode and I print the value of System.name the spaces are truncated! Whereas the same query in ReadOnly mode will print the name with the spaces.   Has anyone seen this problem?   Thanks, Vishal. Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments.