Character Data Types in SQL
Abstract
SQL is not a string processing language. Character data in SQL is supported by a simple function library.
Keywords
CHARACTER(n)
CHAR(n)
NATIONAL CHARACTER(n)
NATIONAL VARYING CHARACTER(n)
NCHAR(n)
NVARCHAR(n)
UNICODE
String Equality
Soundex
Metaphone
New York State Identification and Intelligence System
Cutter tables
Sql-89 defined a CHARACTER(n) or CHAR(n) data type, which represents a fixed-length string of (n) printable characters, where (n) is always greater than zero. Some implementations allow the string to contain control characters, but this is not the usual case. The allowable characters are usually drawn from ASCII or EBCDIC character sets and most often use those collation sequences ...
Get Joe Celko's SQL for Smarties, 5th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
