Questions marks with Sql Server

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
us22
Forum Newbie
Posts: 1
Joined: Wed Jun 17, 2009 4:07 am

Questions marks with Sql Server

Post 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
Post Reply