Re: Re: MSSQL Query - Unicode data in a Unicode-only collation or ntext data cannot be sent

Hi Ollie, Thank you for your reply. I was mistaken. I am using PHP 4.1.1 loaded as a CGI. I am using Apache because I am from a Solaris/Linux background, and I know how to use it better. I don't feel comfortable enough with IIS to secure it down (with all that NIMDA and CodeRed floating around). Our company is going to implement SQL Server 2000, so I want to try it out. I used the sample PHP script from PHP's Web site to connect. Here is the code: <?php $hostname = "localhost"; $username = "username"; $password = "password"; $dbName = "Northwind"; MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND."); mssql_select_db($dbName) or DIE("Table unavailable"); $query = "SELECT * FROM Employees"; $result = MSSQL_QUERY($query); $number = MSSQL_NUM_ROWS($result); $i=0; if ($number == 0) : print "No data?"; elseif ($number > 0) : print "Data:"; while ($i < $number) : $name = mssql_result($result,$i,"Name"); print $name; print ""; $i++; endwhile; endif; ?> I modified it to grab information from Northwind's Employee table. I didn't know Unicode was something that was defined. I will try to make a sample database with 'more simple' database fields to see if that works. I just wanted to do a quick test to grab data. I see it'll take me a little longer to learn MSSQL. Thanks! william -- William Fong - wfong@mookandblanchard.com Phone: 626.968.6424 x210 | Fax: 626.968.6877 Wireless #: 805.490.7732 | Wireless E-mail: 8054907732@mobile.att.net ----- Original Message ----- From: "Oliver Cronk" <oliver@cronky.net> To: "Php-Db ML" <php-db@lists.php.net>; <sql@mookandblanchard.com> Sent: Thursday, January 31, 2002 3:19 PM Subject: [PHP-DB] Re: MSSQL Query - Unicode data in a Unicode-only collation or ntext data cannot be sent > Hi there, > > PHP4.0.6 on IIS / Windows 2000 works fine with SQL Server 2000 (I have teste > this quite throughly) I don't know about unicode fields however as I don't/ > haven't used them in any of my databases. I know that varchar fields have a > few issues (can't retrieve more that 255 characters, you have to use text > fields instead - which aren't queryable). > > What are you using to connect to MS-SQL? The MSSQL PHP library functions I > hope (NOT ODBC its much slower IMO). Why are you using Apache on Win32 may > I ask(is it for apache functionality you can't get with IIS?)? > > Whats the query that you are sending in your test.php script? > > Cheers > > Ollie > > <sql@mookandblanchard.com> wrote in message > > news:<20020131064300.8AB745CBDE@mail.mookandblanchard.com>... > > Getting this error: > > > > Warning: MS SQL 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:\webroot\test.php on line 13 > > > > Warning: MS SQL: Query failed in C:\webroot\test.php on line 13 > > > > Warning: Supplied argument is not a valid MS SQL-result resource in > C:\webroot\test.php on line 15 > > > > --- > > > > Using Windows 2000 Server with Apache 1.3.23 and PHP4.0 with SQL Server > 2000. Any ideas? PHP's site didn't mention anything about SQL Server 2000. > > > > Thanks! > > > > will > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >