Does the tilde character ~ represent anything specific?

[smbunn]

My client has a group of tags llisted under "~ mimics" as a group name.  I cannot read them with my OPC DA client and suspect that the tilde character is being rejected as a special character.  Does the tilde character mean anything in geoSCADA, or is this just a random choice that is disrupting my ability to read data?

[BevanWeiss · Accepted solution]

It’s just a convenient choice of non-alphabet that doesn’t have special meaning elsewhere.

In SQL _ and % are used for wildcards, ? Is used for query placeholder

‘ and “ are used as string delimiters in different languages, so would be confusing

. is the FullName separator…

so not many options left, ~ was used in some early Serck stuff, and kind of just multiplied from there.

I’d try to follow up either your OPC-DA client vendor, it shouldn’t really have any issue with that character.

changing names of things in unknown DBs is a recipe for disaster… especially ~ things, they’re normally special enough to want to be sorted graphically to the top

[AdamWoodlandToo]

~ became defacto for "common things" especially when made consistent between multiple systems such as "~Config", as Bevan mentioned all it really does is move them up the Geo SCADA tree alphabetically so it is much easier to find (although in some third party clients ~ comes after Z, maybe that is causing the issue here?)

! has also been used, comes after the ~ but before A and only ever really seen it for system monitoring type groups