RE: Bug in JDBC driver

Hi Jyri,

could you provide some more details on the problem:

- is the database UNICODE, is the connection with 'unicode=yes'?
- do you use a specific SQL mode (Oracle, Internal, ...)

and finally - how did your changed SQL statement look like (there
is more than one call to ASCII in it ...).

Thanks

Alexander Schröder
SAP DB, SAP Labs Berlin


> -----Original Message-----
> From: Jyri Seiger [mailto:[email protected]]
> Sent: Monday, May 05, 2003 2:10 PM
> To: SAP DB
> Subject: [SAP DB Dev] Bug in JDBC driver
> 
> 
> Hello,
> 
> I am using the latest version of SAP DB (7.4) and the latest JDBC
> driver for it, and I found that getColumns method of 
> DatabaseMetaDataSapDB
> class fails with an error -8006 "Data types must be compatible".
> I checked the source and the problem is that there is an 
> error in SQL query.
> ASCII function call should be removed from this query and 
> then it works fine.
> 
> --
> Best regards,
> Jyri Seiger
> 
> _______________________________________________
> sapdb.sources mailing list
> [email protected]
> http://listserv.sap.com/mailman/listinfo/sapdb.sources
>