Re: Efficient way to access MS SQL server
| From: | Frank M. Kromann | Date: | Tue, 05 Feb 2008 00:49:29 +0000 |
| Subject: | Re: Efficient way to access MS SQL server | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44569@lists.php.net to get a copy of this message | ||
Using the mssql extension based on Microsofts library (ntwdblib.dll) will
have limitations like column length 30 bytes and character columns has a
max length of 255 bytes.
If you use the same extension based on the FreeTDS version of the dblib
library these limitations goes away. Even on Windows platforms.
- Frank
> There's a limit of 30 characters for column names, but only if you
> connect to your mssql server from windows (more info on
> http://hu2.php.net/mssql).
>
> > The native SQL driver for PHP has a problem with a limit on the number
> > of characters in a string, so can't use that.
> I'm not sure what Charly means by this though...
>
> Evert
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>