Re: ODBC with SQL Server
| From: | David Otton | Date: | Sun, 15 Feb 2004 12:09:07 +0000 |
| Subject: | Re: ODBC with SQL Server | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-177731@lists.php.net to get a copy of this message | ||
On Fri, 13 Feb 2004 12:30:42 +0100, you wrote:
>I have a connectoin ODBC with a SQL Server database. A table has a field of
>type 'nvarchar'. This field contains japanese characters.
>How can I read these japanese characteres? When I read (with: "select name
>from data") only read '?' character.
I've come across this recently when talking to MySQL from a Windows
application. ODBC didn't like transferring 8-bit data - BLOB and TEXT fields
end up as strings of ?.
On Windows, you have to open a seperate stream object (ADO >= 2.5) to
recover the binary data. How that translates to the ODBC library used by
MySQL I have no idea... odbc_binmode() may help, possibly.
Have you considered just using the mssql_* library?