us22 Posted June 17, 2009 Share Posted June 17, 2009 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.