This is true if Shaun was using MySQL, but he is using MSSQL. MSSQL allowas you to declare char and varchar fields with lengths up to 8000 characters. Unfortunately the extension bundled with PHP cannot read beyond the first 255 characters. This is primarily due to the fact that the extension was built using DB-LIB, which does not adequately support all of the new data types introduced in MSSQL 7.0 and 2000. -- bob On Mon, 11 Aug 2003, Matthew McNicol wrote: > > Shaun, the MySQL manual suggests that you have hit your limit using the > VARCHAR field type (255 characters). To store 6,000 characters have you not > considered using the TEXT field type? > > > > "6.2.3.1 The CHAR and VARCHAR Types > The CHAR and VARCHAR types are similar, but differ in the way they are > stored and retrieved. > > The length of a CHAR column is fixed to the length that you declare when you > create the table. The length can be any value between 1 and 255. (As of > MySQL Version 3.23, the length of CHAR may be 0 to 255.) When CHAR values > are stored, they are right-padded with spaces to the specified length. When > CHAR values are retrieved, trailing spaces are removed. > > Values in VARCHAR columns are variable-length strings. You can declare a > VARCHAR column to be any length between 1 and 255, just as for CHAR columns. > However, in contrast to CHAR, VARCHAR values are stored using only as many > characters as are needed, plus one byte to record the length. Values are not > padded; instead, trailing spaces are removed when values are stored. (This > space removal differs from the SQL-99 specification.) No case conversion > takes place during storage or retrieval. > > If you assign a value to a CHAR or VARCHAR column that exceeds the column's > maximum length, the value is truncated to fit." > > > > ----- Original Message ----- > From: "Shaun Bentley" <shaun.bentley@ntlworld.com> > To: <php-db@lists.php.net> > Sent: Monday, August 11, 2003 11:23 AM > Subject: PHP & MSSQL > > > > Hi > > I am currently trying to use PHP and MSSQL together but I am having a > > few problems. > > > > I can enter data into the Db OK, but when pulling the data back to display > > on the page, the string cuts to around 250 chars. The Db field is VarChar > > 6000 and I can see the whole data in the field. > > > > I have tried pulling the data out as object, array & row but always lose > the > > end. > > > > Any help please! > > > > Shaun > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.506 / Virus Database: 303 - Release Date: 01/08/2003 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
