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

Yeah, I create a simple table with simple char data type. Works great. No, sorry, I don't know T-SQL. I've just started using MSSQL. I've only used MySQL, and even that was using very simple queries. Once I have a better understanding of MSSQL, I will probably pick up the T-SQL book. Thanks. will -- 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: <sql@mookandblanchard.com>; "Php-Db ML" <php-db@lists.php.net> Sent: Thursday, January 31, 2002 6:49 PM Subject: Re: [PHP-DB] Re: MSSQL Query - Unicode data in a Unicode-only collation or ntext data cannot be sent > No worries, there's an "IIS-Lockdown" Tool available from Microsoft if you > want to play around with IIS - and not have to worry about code red etc (you > still need to keep it regularly updated patches wise though - I guess thats > the advantage of apache). > > The sample script is fine - thats how I got into MSSQL/PHP many moons ago. > Note that it isn't very efficient (you can write a much faster script using > mssql_fetch_array() and arrays) as it makes a lot of requests on the db. I > think you are better off creating a simple DB in MSSQL enterprise manager > (dead easy once you get the hang of it - much better than access IMHO but > thats not very hard!). > > Do you know anything about Transactional SQL? If you do you might be able > to help me in return (see my question in another newer thread)! > > If you want any more help let me know, I have been using this stuff for a > while and don't mind sharing info (seeing as I'm probably not going to get > to use PHP once I'm a graduate in a few months). > > Cheers > > Ollie > > "William Fong" <sql@mookandblanchard.com> wrote in message > news:<001501c1aab2$79d83e40$0ac8a8c0@willbox>... > > 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 > > > > > > > > > > > >