Vishal, can you please file a bug report for this at
http://bugzilla.exolab.org Regards Werner PS And please do not send HTML messages to this mailing list .... --Original Message Text--- From: [EMAIL PROTECTED] Date: Thu, 11 Mar 2004 19:40:24 +0530 Clean Clean DocumentEmail MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband- size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin- bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} 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. ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
