Hi Marcin > -----Original Message----- > From: Marcin P [mailto:[EMAIL PROTECTED]] [some details snipped] > A few days ago I decided to make some tests with new (7.4beta) > version of SAP DB. Firstly, I installed a new driver (ODBC 7.4 - on > Windows), > and tried to connect to SAP DB 7.3.0.29 database. Connections are made > without > any problems but whenever I try to use some Polish diacritic > chars (even as > a part of string) I get the message, > that the query could not be translated to Unicode. Why is that?
All ODBC drivers after 7.3.0 are Unicode enabled. Thit means under Windows, that the driver manager uses the Unicode API calls, where possible. The necessary mapping is done by the driver manager. That means, there is now a user code page to Unicode mapping before our driver gets the data. Unfortunately, the driver was only capable to translate Unicode back to ASCII for the code page ISO 8859-1. So having Polish characters it cannot translate it into ISO 8859-1 and reports an error. For the 7.3.0 driver, the driver manager does no mapping and nothing is converted forth and back, meaning, that the DB happily handles all the characters as there are. Meanwhile a fix is available (the current ODBC74.exe on our ftp server). Now the conversion Unicode -> ASCII is done regarding to the user's default code page (under Windows). If you don't have a Unicode DB there is no need to use an ODBC driver higher than 7.3.0. Sorry for any inconvenience. Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin SAP DB is open source. Get it! www.sapdb.org _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
