Zulu
Posts: 33
|
| Posted: 02/05/2005, 12:25 PM |
|
I am using PHP 4.3, MS-SQL Server 2000 on MS-Win XP Professional
I was trying with simple test codes like below:
<?php
$dbh=mssql_pconnect ("ZAMANS", "sa", "") or die ('Cannot connect to server');
mssql_select_db("Northwind",$dbh) or die ('Cannot select db');
$result=mssql_query('SELECT Categories.* FROM Categories',$dbh);
$reccount=mssql_num_rows($result);
echo $reccount;
?>
...and got this:
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 .7 or earlier. (severity 16) in c:\inetpub\wwwroot\test.php on line 4
Warning: mssql_query() [function.mssql-query]: Query failed in c:\inetpub\wwwroot\test.php on line 4
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in c:\inetpub\wwwroot\test.php on line 5
|
 |
 |
peterr
Posts: 5971
|
| Posted: 02/05/2005, 12:35 PM |
|
I don't know the answer, but since this is not related to CodeCharge Studio you may want to do some reading about this problem here:
http://www.google.com/search?hl=en&q=%22Unicode+data+in...+data+cannot%22
http://groups-beta.google.com/groups?q=%22Unicode%20dat...lr=&sa=N&tab=wg
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
