Table of Contents
Ispirer Website
Ispirer Capabilities - Sybase Migration
Free Trial
Sybase ASA - Identifiers
This article describes identifiers in Sybase ASA.
Identifier Rules
Sybase ASA - Identifier Rules | |
---|---|
First Character | An alphabetical character, underscore (_), at sign (@), pound sign (#) and dollar sign ($) |
Subsequent Characters | Alphanumeric characters, underscore (_), dollar sign ($), pound sign (#) and at sign (@) |
Maximum Length | 128 characters |
Case Sensitivity | Identifiers are case insensitive |
Standards | ANSI SQL |
Identifiers - Differences between Sybase ASA and other Databases
Database | Identifiers | First Character | Subsequent Characters | Max Length |
---|---|---|---|---|
Oracle | Oracle Identifiers | Not allowed: _ , @ , $ and # | Not allowed: @ | 30 |
SQL Server | SQL Server Identifiers | Not allowed: $ | No differences | 128 |
IBM DB2 | IBM DB2 Identifiers | Not allowed: _ , $, @ and # | Not allowed: @, # and $ | 128 |
MySQL | MySQL Identifiers | Allowed: digit Not allowed: _, $, @ and # | Not allowed: # and @ | 64 |
PostgreSQL | PostgreSQL Identifiers | Not allowed: @, $ and # | Not allowed: # and @ | 63 |
Sybase ASE | Sybase ASE Identifiers | Not allowed: $ | No differences | 255 |
Informix | Informix Identifiers | Not allowed: @, # and $ | Not allowed: @ and # | 128 |
Teradata | Teradata Identifiers | Not allowed: @ | Not allowed: @ | 30 |
HP Neoview | HP Neoview Identifiers | Not allowed: _, @, # and $ | Not allowed: @, # and $ | 128 |
Interbase/Firebird | Interbase/Firebird Identifiers | Not allowed: _, @, # and $ | Not allowed: # and @ | 67 |
Quoted or Delimited Identifiers
Sybase ASA - Quoted Identifiers | |
---|---|
Quotation Marks | Double quotation marks (“”) and brackets ([]) |
Characters | Any character |
Maximum Length | 128 characters, not including the quotation marks |
Case Sensitivity | Case insensitive. For example, “tab 1” and “Tab 1” are considered the same |
Notes | When QUOTED_IDENTIFIER is set to ON, Sybase ASA follows the SQL-92 rules for the use of double quotation marks (“) and the single quotation mark (') in SQL statements. |
Quoted Identifiers - Differences between Sybase ASA and other Databases
Database | Identifiers | Quotation Marks | Characters | Case Sensitivity |
---|---|---|---|---|
Oracle | Oracle Quoted Identifiers | ”“ | Any except quotes | Case sensitive |
SQL Server | SQL Server Quoted Identifiers | [] and ”“ | Any except quotes | Case insensitive |
IBM DB2 | IBM DB2 Quoted Identifiers | ”“ | Any including quotes | Case sensitive |
MySQL | MySQL Quoted Identifiers | `` and ”“ | Any except quotes | Case sensitive |
PostgreSQL | PostgreSQL Quoted Identifiers | ”“ | Any including quotes | Case sensitive |
Sybase ASE | Sybase ASE Quoted Identifiers | [] and ”“ | Any except pound sign (#) as the first character | Case insensitive |
Informix | Informix Quoted Identifiers | ”“ | Any including quotes | Case sensitive |
Teradata | Teradata Quoted Identifiers | ”“ | Any including quotes | Case insensitive |
HP Neoview | HP Neoview Quoted Identifiers | ”“ | Any except at sign (@), forward slash (/), circumflex character (^) as the first character and space(s) as the last character(s) | Case sensitive |
Interbase/Firebird | Interbase/Firebird Quoted Identifiers | ”“ | Any character except space(s) as the last character(s) | Case sensitive |