Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Re: [Ian] Creating table with a TEXT column.

Jun 19, 2002, 4:24 PM
Paul
Veteran (19537 posts)
Jun 19, 2002, 4:24 PM
Views: 9798
Shortcut
Quote Reply
Re: [Ian] Creating table with a TEXT column. In reply to
CHAR(1000) ?

>>
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.
<<

It doesn't look like you can do 1000, but also I don't like the padding in CHAR columns :(
Subject Author Views Date
Thread Creating table with a TEXT column. Paul 10125 May 28, 2002, 12:29 PM
Thread Re: [Paul] Creating table with a TEXT column. 		Paul 9832 May 28, 2002, 12:32 PM
Thread Re: [Paul] Creating table with a TEXT column. 		Matt G 9813 Jun 19, 2002, 3:27 PM
Thread Re: [Matt Glaspie] Creating table with a TEXT column. 		Paul 9794 Jun 19, 2002, 3:31 PM
Thread Re: [Paul] Creating table with a TEXT column. 		Ian 9795 Jun 19, 2002, 4:16 PM
Thread Re: [Ian] Creating table with a TEXT column. 		Paul 9798 Jun 19, 2002, 4:24 PM
Post Re: [Paul] Creating table with a TEXT column. 		Ian 9762 Jun 19, 2002, 4:26 PM