Index  Up  <<  >>  


Character usage restrictions

To review, database identifiers, field names, and product codes (database keys) are restricted in the characters they may use. A short table showing restrictions:

                                       Legal characters
                                       ---------------------
    Database identifiers               A-Z a-z 0-9 _
    Field names                        A-Z a-z 0-9 _ # - . /
    Database keys (product code/SKU)   A-Z a-z 0-9 _ # - . /
    Database values                    Any (subject to field/record delimiter)

You probably should restrict the field names to the same set of characters as database identifiers -- this will prevent conflict with external database programs, noticeably SQL databases which use the period (.) as a table.field separator.


Index  Up  <<  >>