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

ENUM fields with ' () in v. 2.2.1

Dec 9, 2004, 5:57 PM
Payooo
User (424 posts)
Dec 9, 2004, 5:57 PM
Post #1 of 3
Views: 1486
Shortcut
Quote Reply
ENUM fields with ' () in v. 2.2.1
Hi,

I am trying to create an ENUM field with a list of countries.

But, it won't accept countries with ' ( ) in their names:

Example:

China (People's Republic of)
Korea, Democratic People's Republic of
...

I can create the field but I can't Resync Database after ...

Error: GT::SQL::Creator (20936): enum('China (People''s Republic of)','Korea, Democratic People''s Republic of') is not a supported type at GT::SQL::Admin::editor_update_def line 1946.

Unsure

Thanks in advance!
Dec 9, 2004, 11:45 PM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Dec 9, 2004, 11:45 PM
Post #2 of 3
Views: 1414
Shortcut
Quote Reply
Re: [Payooo] ENUM fields with ' () in v. 2.2.1 In reply to
Try a CHAR, and use a SELECT field. Then, just enter values for the "show" and "database values" areas (idential, so they match up).

I've never really ad much luck with ENUM's either :(

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Dec 10, 2004, 5:34 AM
Payooo
User (424 posts)
Dec 10, 2004, 5:34 AM
Post #3 of 3
Views: 1417
Shortcut
Quote Reply
Re: [Andy] ENUM fields with ' () in v. 2.2.1 In reply to
Thanks Andy Wink