Hello! I'm using the latest SAPDB ODBC driver (version 7.4.03.pre11 for Linux) to access a SAPDB 7.4.3 based database from PHP. The database instance is an Unicode instance (created with paramters _UNICODE=YES and DEFAULT_CODE=UNICODE).
I'm working on a web-app which receives UTF-8 encoded multilingual form data that should be inserted UCS-2 encoded into this database. (Because UPPER/LOWER/ORDER BY/etc. must work correctly on these strings.) I tried to... 1.) ...execute UTF-8 encoded SQL statements, with the result that the multibyte-parts of UTF-8 strings were converted byte-by-byte and stored as series of single UCS-2 characters. 2.) ...execute SQL statements converted to UCS-2 completely. Result: Error -3005 POS(1): Invalid SQL statement. 3.) ...execute SQL statements where only the character-values were converted to UCS-2 and the SQL-code was left ASCII encoded. Result: Error -3014 POS([first UCS-2-char]): Invalid end of SQL statement. So what's the trick to get that working? Are there any conversion mechanisms that can be used on database level or has the conversion to happen on application level? Is there a way to get UPPER/LOWER/ORDER BY/etc. working on UTF-8 encoded content (which would be best for me anyway)? Thank you! Hannes -- COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test -------------------------------------------------- 1. GMX TopMail - Platz 1 und Testsieger! 2. GMX ProMail - Platz 2 und Preis-Qualit�tssieger! 3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
