Re: ODBC: Unicode conversion from UTF-8 to UCS-2
Sven Köhler <[email protected]>
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <[email protected]> |
>>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... > > The ODBC driver expects in the ODBC-Wide-API (the functions with > a trailing "W" like SQLConnectW) UCS2 strings in a 2-bytes data type. > SQLWCHAR is defined in sqltypes.h, line 335: He's talking about PHP, and i just looked it up: PHP doesn't offer access to the unicode-aware functions of the ODBC API.