I'm using the J ODBC driver to connect to SQL Server. I'm finding that queries that I run are returning unwanted trailing blanks in all fields. For example from a table field defined as nvarchar(50) I am getting lengths of 100 returned, most of which are spaces as the end. From temp tables I am getting returned lengths of 1000 on data originally sourced from a table field of nvarchar(500). So there seems to be a 2 to 1 increase - perhaps due to the Nvarchar field. But the root issue is why am I getting this in the first place? It persists even if I use RTRIM() in the query.
Is there some way to deal with this at the ODBC level instead of having to having to trim it all after the results are returned (since performance would tank on huge result sets)? Ed Cox Principal Data Analyst Office: (508)382-4943 / Cell Phone: (978)387-9352 [email protected]<mailto:[email protected]> MedMined(tm) _________________________________________________ This message is for the designated recipient only and may contain privileged, proprietary or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. Dansk - Deutsch - Espanol - Francais - Italiano - Japanese - Nederlands - Norsk - Portuguese Svenska: www.cardinalhealth.com/legal/email ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
