Table of ContentsPreviousNext

Ispirer
Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer Database Conversion overview.


Ispirer SQLWays Database Migration Software

Allowed Characters in Identifiers

Table 13 shows the information about the characters allowed to use in identifier names in databases.

TABLE 15. Allowed Characters in Identifiers
Database
 
Identifiers Must Begin with
Subsequent Characters
Delimited Identifiers
Oracle
an alphabetical character
alphanumeric characters, _, $ and #
Supported
IBM DB2
Unix, Windows
an alphabetical character, $, # and @
alphanumeric characters, _, $, # and @
Supported
OS/390
an alphabetical character
alphanumeric characters and _
Supported
AS/400
an alphabetical character
 
alphanumeric characters and _
Supported
Microsoft SQL Server
an alphabetical character, _ , @ and #
alphanumeric characters, _, $, # and @
Supported
Sybase
ASE
an alphabetical character and _
alphanumeric characters, _, $, # and @
Supported
ASA
an alphabetical character and _
alphanumeric characters, _, $, # and @
Supported
MySQL
prior to 3.23.6
alphanumeric characters, _ and $
alphanumeric characters, _ and $
Not supported
3.23.6 or later
characters that are allowed in a file name, except / or .
characters that are allowed in a file name, except / or .
Supported
Pervasive.SQL
an alphabetical character
alphanumeric characters and _
Supported


Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.