odysseous 0 Newbie Poster

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.