Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Bug: add colum char not varchar

Jan 2, 2002, 7:41 PM
pugdog
Veteran / Moderator (6956 posts)
Jan 2, 2002, 7:41 PM
Post #1 of 3
Views: 1619
Shortcut
Quote Reply
Bug: add colum char not varchar
Alex,

When adding in a new column, and picking a type 'char', we get 'char' rather than 'varchar'. Didn't the old default used to be 'varchar' ?? At least make that an option for MySQL users :)




PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Jan 3, 2002, 10:41 AM
Alex
Administrator (9387 posts)
Jan 3, 2002, 10:41 AM
Post #2 of 3
Views: 1571
Shortcut
Quote Reply
Re: [pugdog] Bug: add colum char not varchar In reply to
Hi,

Do you get a CHAR in the actual database? Links SQL will say CHAR regardless I believe. Also, MySQL will convert any CHAR's to VARCHAR's if the table already has an existing varchar/text.

Cheers,

Alex
--
Gossamer Threads Inc.
Jan 3, 2002, 1:49 PM
pugdog
Veteran / Moderator (6956 posts)
Jan 3, 2002, 1:49 PM
Post #3 of 3
Views: 1543
Shortcut
Quote Reply
Re: [Alex] Bug: add colum char not varchar In reply to
Ok,

MySQL does show it as a VarChar, but Links shows the originally created fields as "varchar" but the added fields as "char".

Confusing.




PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.