Hi.
I have a IIS server with php3 installed. I have SQL server database
and data stored in unicode format (nvarchar fields). In header of my
php I have the meta: <meta HTTP-EQUIV="content-type"
CONTENT="text/html; charset=UTF-8">.
I have the following problem:
- I trie to do a query using ODBC (version 3.525.1022.0) and SQL
Server odbc driver (version 200.85.1022.00) . The query doesn't
retrieve information in utf format and accents and extra characters
aren't showed correctly.
- I trie to di the query usin native OLE DB. I use mssql funtions and
the problem is the same.
If I install php4 and I use "new
COM("ADODB.Conn ection",NULL,CP _UTF8);", then it works correctly.
Anybody knows if its posible to retrieve data from sql-server in utf-8
format using php3?
I see in other postings that odbc driver only accept utf-8 in version
3.7 or higher? Is it true? If is true, where I can download odbc
driver 3.7?
Thank's in advance.
Miki.
I have a IIS server with php3 installed. I have SQL server database
and data stored in unicode format (nvarchar fields). In header of my
php I have the meta: <meta HTTP-EQUIV="content-type"
CONTENT="text/html; charset=UTF-8">.
I have the following problem:
- I trie to do a query using ODBC (version 3.525.1022.0) and SQL
Server odbc driver (version 200.85.1022.00) . The query doesn't
retrieve information in utf format and accents and extra characters
aren't showed correctly.
- I trie to di the query usin native OLE DB. I use mssql funtions and
the problem is the same.
If I install php4 and I use "new
COM("ADODB.Conn ection",NULL,CP _UTF8);", then it works correctly.
Anybody knows if its posible to retrieve data from sql-server in utf-8
format using php3?
I see in other postings that odbc driver only accept utf-8 in version
3.7 or higher? Is it true? If is true, where I can download odbc
driver 3.7?
Thank's in advance.
Miki.