O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required