Cannot store strings with space in enum

DBML Syntax
1

I am using this software to document my database. I want to store enum values as strings which have spaces in them. When I do a syntax errors shows up

Expected " ", “[”, comment, or newline but “A” found.

The field in my database is below;

en enum(‘Generation Alpha (0-12)’,‘Teenager (13-17)’,‘Generation Z (18-22)’,‘Millennial (23-29)’,‘Generation X (30-50)’,‘Baby Boomer (50+)’,‘Other’,‘All’) DEFAULT NULL,

2

In DBML, you can use double quotes to store enum values as strings, such as “Generation Alpha”.

1 Like