Jump to content

Problem: Questions marks with Sql Server


us22

Recommended Posts

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 : " ? ? ? ? ? ? ? ? "

 

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

 

this is my code:

 

$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

Link to comment
https://forums.phpfreaks.com/topic/162535-problem-questions-marks-with-sql-server/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.