The "bug" as you call it is a limitation in the libraries from Microsoft. SQL Server ships with a set of C-Libraries called DBLIB, and these were developed for MSSQL Server 4.x and 6.x. In version 7.x Microsoft extended char and varchar column max length to 8000 but did not update the DBLIB stuff.
So the MSSQL extension does not use (slow) ODBC to communicate with the server, but jus a set of old libraries. - Frank > 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 > [EMAIL PROTECTED] > > > -----Original Message----- > > From: Ryan Marrs [mailto:[EMAIL PROTECTED]] > > Sent: Monday, November 12, 2001 5:15 AM > > To: 'Michael Schmidt'; '[EMAIL PROTECTED]' > > 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:[EMAIL PROTECTED]] > > Sent: Monday, November 12, 2001 8:12 AM > > To: [EMAIL PROTECTED] > > 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: [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] > > > > > > > -- > 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]
