Managing quotation marks around values

Chapter 3 Building Physical Diagrams

Managing quotation marks around values

For a domain or a column, standard parameters can indicate minimum, maximum, and default values as well as a list of values.

In general, if the data type of domain or column is a string data type, quotation marks surround its values in the generated script. The generation of single or double quotation marks depends on the target DBMS.

However, quotation marks are not generated in the following cases:

You define a data type that is not recognized as a string data type by PowerDesigner
Value is surrounded by tilde characters
Value is a keyword defined in the DBMS (for example, NULL)

In addition, if the value is already surrounded by quotation marks additional quotation marks are not generated.

The following table shows the way a value for a string data type is generated in a script:

Value for string data type	Result in script
Active	'Active'
'Active'	'Active'
"Active"	'"Active"'
~Active~	Active
NULL	NULL