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 - [EMAIL PROTECTED]
Phone: 626.968.6424 x210  |  Fax: 626.968.6877
Wireless #: 805.490.7732    |  Wireless E-mail: [EMAIL PROTECTED]




----- Original Message -----
From: "Oliver Cronk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Php-Db ML" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]> 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 - [EMAIL PROTECTED]
> > Phone: 626.968.6424 x210  |  Fax: 626.968.6877
> > Wireless #: 805.490.7732    |  Wireless E-mail:
[EMAIL PROTECTED]
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "Oliver Cronk" <[EMAIL PROTECTED]>
> > To: "Php-Db ML" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > 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
> > >
> > > <[EMAIL PROTECTED]> wrote in message
> > > news:<[EMAIL PROTECTED]>...
> > > > 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: [EMAIL PROTECTED]
> > > For additional commands, e-mail: [EMAIL PROTECTED]
> > > To contact the list administrators, e-mail:
[EMAIL PROTECTED]
> > >
> > >
> >
> >
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to