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:[EMAIL PROTECTED]]
> Sent: Monday, August 13, 2001 12:11 PM
> To: [EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP Windows 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 Windows 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]
