Hi Everybody,
I have problem with unicode data in SQL server. I could not show data that fileds are nvarchar,nchar,ntext properly on front end.
$myServer ='servername\SQLEXPRESS,1433';
$myUser = 'odysseous';
$myPass = 'ody1';
$myDB = "eSQL";
// connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");
// select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
or die("Couldn't open database $myDB");
I am connecting to SQL like above. I take data from db by ucing Cast ing method.
but the results look like ??O???
What can I Do?