Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: steen.jensen on May 17, 2018, 08:30:30 am
-
As a non-programmer I have possible made some "sink-holes" for my self.
I have created Tagged-Values names with space, hyphen that I have trouble with in SQL-scripts.
Are there any other characters I should avoid? Underscore, National char as öäå etc etc
-
There are no standards per say, You are right, we always stick to the code / sql safe naming convention (avoiding spaces or special characters). Underscores are safe though. Some gurus in this forum might have listed down the specific characters that are sure fail.
-
Must avoid ::
-
The use of special characters is mainly defined by the underlying database. If you use a database/driver that supports unicode, EA works fine with special characters.
-
The other suggestion that I'd make is that using valid xml attribute names (https://www.w3.org/XML/xml-V10-4e-errata#E09) will help if you're wanting to export xmi (although EA will round trip the name with itself)
Short summary, don't start with 'xml', or a number. Avoid punctuation except ':', '.', '-', '_'. Don't include spaces.
-
What about mix o capital & small letters in tagged value names??
-
IIRC case sensitivity (e.g. whether "Taggedvalue" and "TaggedValue" are seen as being different) depends on the database you use.
q.