Home
|
Previous Page
|
Next Page
SQL Features
In This Chapter
Naming Database Objects
Rules for Identifiers
Non-ASCII Characters in Identifiers
Qualifiers of SQL Identifiers
Owner Names
Pathnames and Filenames
Delimited Identifiers
Valid Characters in Identifiers
Using Character Data Types
Localized Collation of Character Data
The NCHAR Data Type
The NVARCHAR Data Type
Performance Considerations
Other Character Data Types
The CHAR Data Type
The VARCHAR Data Type
The LVARCHAR Data Type (IDS)
The TEXT Data Type
Handling Character Data
Specifying Quoted Strings
Specifying Comments
Specifying Column Substrings
Column Substrings in Single-Byte Code Sets
Column Substrings in Multibyte Code Sets
Partial Characters in Column Substrings
Errors Involving Partial Characters
Partial Characters in an ORDER BY Clause
Specifying Arguments to the TRIM Function
Using Case-Insensitive Search Functions (IDS)
Collating Character Data
Collation Order in CREATE INDEX
Collation Order in SELECT Statements
Comparisons with MATCHES and LIKE Conditions
Using SQL Length Functions
The LENGTH Function
The OCTET_LENGTH Function
The CHAR_LENGTH Function
Using Locale-Sensitive Data Types
Handling the MONEY Data Type
Specifying Values for the Scale Parameter
Format of Currency Notation
Handling Extended Data Types (IDS)
Opaque Data Types
Complex Data Types
Distinct Data Types
Handling Smart Large Objects (IDS)
Using Data Manipulation Statements
Specifying Conditions in the WHERE Clause
Specifying Era-Based Dates
Loading and Unloading Data
Loading Data into a Database
Unloading Data from a Database
Loading with External Tables (XPS)
Loading Simple Large Objects with External Tables (XPS)
Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]