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]
