Page 1 of 1

Questions marks with Sql Server

Posted: Wed Jun 17, 2009 4:26 am
by us22
good day

i have problem with encoding or character set - really i don't know - on my SQL server 2005 with PHP

my problem is when i have execute query with php form database the result will questions marks like : " ???????? "

into database the character displayed in correct way but when i execute query from php by ODBC that happen

this is my code:

Code: Select all

 
$sqlconnect=odbc_connect($dsn,$username,$password);
$sql = odbc_exec($sqlconnect, "SET TEXTSIZE 2147483647");
 
         $sql = "SET ROWCOUNT 10 SELECT * FROM [databasename].[dbo].[all]";
         $result23 = odbc_exec($sqlconnect, $sql);
         $row = odbc_num_fields($result23);
 
 

any one can help


note: I'm very sorry but my English is weak