Hello Hannes, As also the PHP ODBC functions return their results as strings, there is little hope here fon convincing them to do something with Unicode. All columns of the result set are bound as SQL_C_CHAR by PHP, any Unicode data would be an SQL_C_WCHAR or (if UNICODE defined) an SQL_C_TCHAR ...
Unfortunately, there is also no kind of SQL function in MaxDB that can generates CHAR UNICODE data from some encoded input, or encodes CHAR UNICODE data e.g. into UTF8. As long as you don't want searching or sorting or calling of functions like LENGTH, you may put that UTF8 into a normal (VAR)CHAR ASCII column, but I fear this will have only little use for a real application, as that's the normal job of the database ... So, there is probably no real trick. Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Hannes Edinger [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 14, 2003 12:52 PM > To: [EMAIL PROTECTED] > Subject: Re: ODBC: Unicode conversion from UTF-8 to UCS-2 > > > Thanks Thomas! Thanks Sven! > > Didn't know that this is a matter of PHP-ODBC and not of SAPDB... Now > I'm really in trouble! :-) > > Is there any trick to get Unicode encoded data into a Unicode column > without using the ODBC-Wide-API? > > Regards, > Hannes > > Sven K�hler wrote: > > >> 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. > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
