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

             

Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.