RE: [PHP] Microsoft SQL Server varchar(500) field text concatenated at 255 characters.

http://www.mysql.com/doc/en/CHAR.html VARCHAR can only be 255 characters in length. Here's some useful info: # BIGINT UNSIGNED = 8 Byte = FFFFFFFFFFFFFFFF = 18446744073709551615 # INT UNSIGNED = 4 Byte = FFFFFFFF = 4294967295 # MEDIUMINT UNSIGNED = 3 Byte = FFFFFF = 16777215 # SMALLINT UNSIGNED = 2 Byte = FFFF = 65535 # TINYINT UNSIGNED = 1 Byte = FF = 255 # BIGINT SIGNED = -9223372036854775808 to 9223372036854775807 # INT SIGNED = -2147483648 to 2147483647 # MEDIUMINT SIGNED = -8388608 to 8388607 # SMALLINT SIGNED = -32768 to 32767 # TINYINT SIGNED = -128 to 127 # TINYTEXT = 255 # TEXT = 65535 # MEDIUMTEXT = 16777215 # LONGTEXT = 4294967295 > -----Original Message----- > From: Scott Houseman [mailto:scott@junkmail.co.za] > Sent: Friday, March 28, 2003 3:35 AM > To: php-general@lists.php.net > Subject: [PHP] Microsoft SQL Server varchar(500) field text > concatenated at 255 characters. > > > Hi There. > > I am using PHP 4.3.0 on WIN32 to query data from a Microsoft > SQL Server. > One field I am requesting is type VARCHAR size 500. For some > reason, PHP > is returning only the first 255 characters of the text from > that field. > > If I change the field type to TEXT, all of the data in that > field is returned. > > Unfortunately, an ASP application is also using that > database, and when I change > the field type to TEXT, it pukes completely. > I would rather try to resolve the issue in PHP than waste my > time looking at ASP code. > > Has anyone got an idea why this might be hapenning? > > Many thanks. > > Scott > -- > Scott Houseman > Senior Software Developer > Junk Mail Publishing (Pty) Ltd > Tel. +27 12 342 3840 x3806 > Fax. +27 12 342 1842 > Mob. +27 82 491 8021 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >