ansaurus

Question

SQL Server - Special characters not recognise by PHP (ODBC)

Answer 1

A:

What's your character encoding for the ODBC connection? It should be some UTF with proper handling on PHP side...

BarsMonster 2010-07-29 08:04:10

Hi, I am not using any UTF encoding for now. Below is my code...function get_odbc_connection(){ $myServer = "Driver={SQL Server};Server={server_ip_address};Database={database_name}"; $myUser = "{username}"; $myPass = "{pwd}"; $myDB = "{database_name}"; // create connection $connection = odbc_connect($myServer,$myUser,$myPass,SQL_CUR_USE_ODBC); // test connection if (!$connection) { echo "Couldn't make a connection!"; exit; } else { return $connection; }}

aayushi 2010-07-29 08:15:53

Answer 2

+1 A:

Hi, I use some special MSSQL query converter and then ICONV in the PHP side like this:

   SELECT  CAST(Remarks AS TEXT) Remarks FROM r_table;

And in the PHP, say the text is in CodePage 1255:

   iconv('CP1255', 'UTF-8', $remark);

hope that's helps.

aviv 2010-07-29 08:09:28

Hi Aviv.. it works !!! Many Many Thanks. :-)

aayushi 2010-07-29 09:50:11

So vote for it ;-) and mark it as an answer

aviv 2010-07-29 11:46:13

ansaurus

tags:

views:

answers:

SQL Server - Special characters not recognise by PHP (ODBC)

related questions