Character Set issue using SQL Server and ODBC in php

Question

I connected to to sqlsever2008 with odbc(with dsn) and php but problem is that when I retrieve information from that it has character like ��. My datatype in sqlserver is nvarchar. Any idea why it is happening?

NOTE: The page is utf8.

Edit:

I use echo utf8_encode(odbc_result($this->result,'name') ); and characters are like:

ÂãæÒÔ ÒÈÇäÂãæÒ

i retrieve information like this:

odbc_result($this->result,'name')

have you checked if you had a `BOM` issue? I always check that too. — Funk Forty Niner, May 29 '13 at 12:51
what is your sql statement i mean.also see http://stackoverflow.com/questions/2750244/php-odbc-encoding-problem and http://stackoverflow.com/questions/1230971/inserting-unicode-characters-with-php-odbc-ms-sql — Amir, May 29 '13 at 14:16
@Mahdi_Nine Consult this link for details http://en.wikipedia.org/wiki/Byte_order_mark — Funk Forty Niner, May 29 '13 at 14:21

score 0 · Answer 1 · answered May 29 '13 at 11:52

0

Try to use utf8_decode() or utf8_encode().

answered May 29 '13 at 11:52

Ingo

99
6

score 0 · Answer 2 · answered May 29 '13 at 12:00

0

It seems, the code page your sql server has been installed is different with your native language. perhaps you need to reinstall the sql server with correct code page.

answered May 29 '13 at 12:00

Amir

4,089
4
16
28

score 0 · Accepted Answer · answered May 30 '13 at 15:30

0

i found the problem.

iconv("Windows-1256", "UTF-8", "$temp")

answered May 30 '13 at 15:30

Mahdi_Nine

14,205
26
82
117

Character Set issue using SQL Server and ODBC in php

3 Answers3

Linked