Special Characters in the EQuIS Database

<< Click to Display Table of Contents >>

Navigation:  Professional > Administration >

Special Characters in the EQuIS Database

EQuIS databases use the ASCII and Extended ASCII character sets. A database collation can also be changed.

 

Overall, characters best avoided in database fields if required by reporting are:

 

the straight single quote (') – can cause errors in certain third-party tools or programs due to the need for special handling within SQL commands and Excel.

the pipe (|) – used in the equis.pipe_filter scalar-valued function to separate multiple selections within a single report parameter for reports.

 

The table below summarizes the scenarios in which special characters or certain phrases can cause issues. With new releases, documentation will be updated to include additional such scenarios as encountered.

 

Special Character

XY Charts
(New)*

Crosstab Reports

Reports** and Forms

Filters

Action Levels

#




Use Custom Filter


,


See Editing EDDs page


See Create New Action Level page

'

See Known Issue



|


Used as a report parameter separator


^




"





Shows a message but does not prevent saving

[




Error on export after filtering; use Custom Filter


SQL commands (e.g. Update, Delete)



Do not use in User Report names


See Create New Action Level page

_WARNING





Do not prepend to Action Level name (already in use). See Create New Action Level page

: or @



Anything following the : or @ symbols will be treated as a parameter in the EQuIS SQL Form or in custom SQL reports.



 

* Use legacy TeeChart XY Charts instead by holding down the Shift key when clicking the XY Chart button.

** May be report-specific; universally-known special character issues are provided here, while specific report pages may detail further limitations, if applicable.