RE: [PHP-DB] Windows, MSSQL varchar>255 caracters?
| From: | Jacob Anderson | Date: | Mon, 12 Nov 2001 14:37:44 +0000 |
| Subject: | RE: [PHP-DB] Windows, MSSQL varchar>255 caracters? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-14253@lists.php.net to get a copy of this message | ||
The VARCHAR(255) "bug" is actually a limitation imposed by ODBC - so I
suspect the MSSQL library uses ODBC for communication with a SQLServer
installation. I've experienced the same problem using Java JDBC and some
older SQL Server drivers. Recent type-4 MS SQL Server drivers for JDBC have
fixed the problem, so no doubt subsequent ODBC implementations will contain
the fix, such as that found in Windows XP.
-- Jake
jwa@javatopia.com
> -----Original Message-----
> From: Ryan Marrs [mailto:rmarrs@strtrade.com]
> Sent: Monday, November 12, 2001 5:15 AM
> To: 'Michael Schmidt'; 'php-db@lists.php.net'
> Subject: RE: [PHP-DB] Windows, MSSQL varchar>255 caracters?
>
>
> I fixed this issue by using a text field instead of a varchar field. For
> some reason, it didn't want to read anything over 255 characters, although
> the data was still stored. Maybe it's a bug, or maybe just a limitation.
>
> Ryan
>
>
> -----Original Message-----
> From: Michael Schmidt [mailto:mschmidt@mittelstrass.de]
> Sent: Monday, November 12, 2001 8:12 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Windows, MSSQL varchar>255 caracters?
>
> Hi All.
>
> With the Microsoft SQL Server it is possible to make a table with
> fields of
> the type varchar which can have more then 255 characters width.
>
> When use a query to get the content, i only get the first 255
> characters all
> others are cut off. (i connect to the DB via the mssql_... commands).
>
> Anyone has a idea how to solve the problem?
>
> Michael
>
>
>
> --
> 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
>
> --
> 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
>
>