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 Quote Link to comment https://forums.phpfreaks.com/topic/162535-problem-questions-marks-with-sql-server/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.