Eve, You can look at http://www.mysql.com/doc/en/Column_types.html
Or: [NATIONAL] CHAR(M) [BINARY | ASCII | UNICODE] A fixed-length string that is always right-padded with spaces to the specified length when stored. The range of M is 0 to 255 characters (1 to 255 prior to MySQL Version 3.23). Trailing spaces are removed when the value is retrieved. CHAR values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given. From version 4.1.0, if the M value specified is greater than 255, the column type is converted to TEXT. This is a compatibility feature. NATIONAL CHAR (or its equivalent short form, NCHAR) is the SQL-99 way to define that a CHAR column should use the default CHARACTER set. This is the default in MySQL. CHAR is a shorthand for CHARACTER. From version 4.1.0, the ASCII attribute can be specified which assigns the latin1 character set to a CHAR column. From version 4.1.1, the UNICODE attribute can be specified which assigns the ucs2 character set to a CHAR column. MySQL allows you to create a column of type CHAR(0). This is mainly useful when you have to be compliant with some old applications that depend on the existence of a column but that do not actually use the value. This is also quite nice when you need a column that only can take 2 values: A CHAR(0), that is not defined as NOT NULL, will occupy only one bit and can take only 2 values: NULL or "". See section 11.3.1 The CHAR and VARCHAR Types. CHAR This is a synonym for CHAR(1). [NATIONAL] VARCHAR(M) [BINARY] A variable-length string. Note: trailing spaces are removed when the value is stored (this differs from the SQL-99 specification). The range of M is 0 to 255 characters (1 to 255 prior to MySQL Version 4.0.2). VARCHAR values are sorted and compared in case-insensitive fashion unless the BINARY keyword is given. See section 13.2.5.1 Silent Column Specification Changes. >From version 4.1.0, if the M value specified is greater than 255, the column type is converted to TEXT. This is a compatibility feature. VARCHAR is a shorthand for CHARACTER VARYING. See section 11.3.1 The CHAR and VARCHAR Types. TINYBLOB TINYTEXT A BLOB or TEXT column with a maximum length of 255 (2^8 - 1) characters. See section 13.2.5.1 Silent Column Specification Changes. See section 11.3.2 The BLOB and TEXT Types. BLOB TEXT A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters. See section 13.2.5.1 Silent Column Specification Changes. See section 11.3.2 The BLOB and TEXT Types. MEDIUMBLOB MEDIUMTEXT A BLOB or TEXT column with a maximum length of 16777215 (2^24 - 1) characters. See section 13.2.5.1 Silent Column Specification Changes. See section 11.3.2 The BLOB and TEXT Types. LONGBLOB LONGTEXT A BLOB or TEXT column with a maximum length of 4294967295 or 4G (2^32 - 1) characters. See section 13.2.5.1 Silent Column Specification Changes. Up to MySQL version 3.23 the server/client protocol and MyISAM tables had a limit of 16M per communication packet / table row, from version 4.x the maximum allowed length of LONGTEXT or LONGBLOB columns depends on the configured maximum packet size in the client/server protocol and available memory. See section 11.3.2 The BLOB and TEXT Types. Hope this helps. Donny > -----Original Message----- > From: Eve Atley [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 27, 2004 9:29 PM > To: [EMAIL PROTECTED] > Subject: Require greater than 255 in varchar? > > > I have a large chunk of text I've attempted to put into a varchar field, > and > it chopped off a chunk of it. If I need to enter text that is greater than > the default 255, what choice should I use instead? > > Thanks, > Eve > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
