0

Following this blog post, I managed to connect to a MSSQL Server form PHP/CentOS machine. I can get result, however I can not use comparison in the where clause. I should be due to different encoding. Here is my code:

$db = new PDO("odbc:USERS", "username", "password");
$sql = "SELECT top 1 name FROM user where name='تست'";
$stmt = $db->prepare($sql);
$result = $stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
var_dump($row);

Also using $name = mb_convert_encoding('تست', 'utf16'); (also 'UCS-2LE' encoding) Was not helpful. How config PHP/MSSQL to use a single encoding?

Improve this question
2
  • Did you try to explicitly set encoding like this: ini_set('mssql.charset', 'UTF-8'); Commented Jun 15, 2015 at 7:06
  • This might be helpful too: stackoverflow.com/questions/1322421/… Commented Jun 15, 2015 at 7:34
Related questions
10
How to change character encoding of a PDO/SQLite connection in PHP?
25
PHP + SQL Server - How to set charset for connection?
1
Php/ODBC encoding problem
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.