Jacob, Ryan MSSQL functions use the Sybase OpenClient or FreeTDS, Some ODBC drivers do impose this restriction, however OpenLink's 4.1 ODBC drivers allow return of the full overloaded data.
Please let me know if you require any assistance in configuring ODBC. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Jacob Anderson [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 12, 2001 9:38 AM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Windows, MSSQL varchar>255 caracters? > > > 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]
