Re: RE: [PHP-WIN] Re: MSSQL Functions

Hi All, The MSSQL Extension is build on Microsofts DB-Library. This library was developed for MS SQL Server 4.x/6.0 and has not been updated since. The Library can still be used with version 6.5, 7.0 and 2000, but is limited to the datatypes known in 6.0 and 6.5. Char and Varchar has a max length of 255 bytes, and there is no direct support for nchar, nvarchar and ntext etc. these types must be casted to another type using CAST(col1, varchar(200)). I have a dialog with a developer at Microsoft trying to get an updated version of DB-Library. If you are developing for Windows only you can use COM and ADODB. This gives you full access to all (most) database features. - Frank > Phill, > > As far as I know, the version shipping with 4.0.6 and much earlier, as early > as 4.0.2 (I think), are built for SQL 7.0. Frank, is that true? You can > check CVS for the latest extensions. > > -Flint > > -----Original Message----- > From: Phillip Bow [mailto:pbow@chatspace.com] > Sent: Monday, August 13, 2001 12:11 PM > To: php-windows@lists.php.net > Subject: [PHP-WIN] Re: MSSQL Functions > > > Nope they are running on my system as we speak. I would be interested to > know if there are any plans to update them though. Last I heard they were > still optimized for SQL 6.5. > -- > phill > > "John Meyer" <john_meyer@geocities.com> wrote in message > news:5.1.0.14.0.20010813120303.009fcec0@pop.mail.yahoo.com... > > Just a quick question on the MSSQL functions: are they unsupported in the > > CGI version of PHP? > > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >