oracle varchar2 data
Posted: Mon May 31, 2004 8:51 pm
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. __________