mssql unicode problem

fatnjazzy

hi
i suppodse to use an existing DB to read from it.
i just got connected to the db and here is the ERROR:

Warning: mssql_query() [function.mssql-query]: message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) in c:\Inetpub\wwwroot\6b\students\mssql.php on line 18

here is the simple code

<?
  $con=mssql_connect("bla","bla",bla"); 
  mssql_select_db("stud",$con);
  $query1=mssql_query("select * from [empl]");
  while($row=mssql_fetch_array($query1))
  {
    print($row['fname']) ;
  }
?>

that does it means?
how do i salve it.
thanks a lot

Kudose

$con=mssql_connect("bla","bla","bla");

you were missing a double quote before the final bla

You can see the error very easily in your post. Do you use a syntax highlighting editor?

fatnjazzy

that is not the error....
its because i changed it here to... bla

fatnjazzy

any one? please?

...

Weedpacket

Sounds like Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.

fatnjazzy

what does ir means?
i canot read it from php?
what can i do?
can someone explain?
thanks

Weedpacket

Seeing as the error message is coming from SQL Server, you'd think SQL Server's web site would have some information, wouldn't you? The obvious thing to try is search. Judging from the information in the first hit (in fact, just by looking at the error message), either upgrade the client library or don't use Unicode data types in the database.

Oh, look at this note on the [man]mssql[/man] page:

Note: In Windows, the DBLIB from Microsoft is used. Functions that return a column name are based on the dbcolname() function in DBLIB. DBLIB was developed for SQL Server 6.x where the max identifier length is 30. For this reason, the maximum column length is 30 characters. On platforms where FreeTDS is used (Linux), this is not a problem.

So that explains why you can't do stuff that was only introduced in SQL Server 7.0. Maybe replacing the version of ntwdblib.dll you're using now with a new one from the client distribution (as suggested in the user notes in [man]mssql_connect[/man] would work.

You know, I didn't know any of that ten minutes ago - every day's a school day.

fatnjazzy

thanks a lot