oracle varchar2 data

[Nick]

background.__i recently had the opportunity to help out another team verifying some data that was loaded into an Oracle 9.2 table - and i used my favorite tool - RR/SQL. (I was also hoping to impress that team with how slick RR-SQL is for quickly validating loaded data - and even get their interest up for using RR-SQL for the reporting needs)____the customer already had Oracle 9.2 Client software installed - which included the Oracle 9.2 ODBC driver.____the test.__i used RR-SQL version 10.1.003 with the Oracle 9.2 ODBC driver and got great results on all columns in the table except a couple of the VARCHAR2 columns - specifically any VARCHAR2 with a size greater than 255 chars.____the problem.__those VARCHAR2 columns showed "garbage" in the RR-SQL output - but no error messages - it was just like the "garbage" was in the Oracle table. ("garbage" in this case was a variety of incorrect characters in lieu of the correct characters - some being non-printable.)____more testing.__i tested the same table using EXCEL/MS QUERY and the Oracle 9.2 ODBC driver and the long VARCHAR2 data columns displayed without any "garbage" at all.____i then tested the same table using BOTH of the DataDirect ODBC Oracle drivers installed with my copy of the RR-SQL developer and using either one - the "garbage" disappears and the correct data was retrieved. So it looks like RR-SQL version 10.1.003 is written to use the DataDirect drivers correctly but not the Oracle 9.2 drivers.____question.__Is this a problem with RR-SQL or the Oracle 9.2 drivers?____request.__I need RR-SQL to work with the installed Oracle 9.2 driver if at all possible. I can not get the customer to installed a different ODBC driver to fix what looks like an RR-SQL error. Especially since all the other applications using the installed Oracle driver work without any problems. __________

[kfleming]

It is indeed an R&R problem with the driver. R&R currently uses a third party interface to ODBC that shows problems with some (particularly newer)drivers. We are working on replacing that interface and will have improvements in an upcoming release whose timeframe is still to be determined.______Kathleen__R&R Support

[Nick]

looking forward to the next release with that fix.__thanks,__nick__