3. Understanding SQL Data Types : SQL Data Types : Character Data Types : C Data Types
 
Share this page                  
C Data Types
Fixed-length c data types accept only printing characters. Non-printing characters, such as control characters, are converted into blanks.
Blanks are ignored when c strings are compared, including when compared against other character data types. For example, this c string:
'the house is around the corner'
is considered equal to:
'thehouseisaroundthecorner'
Note:  Char is the preferred fixed length character type. C is supported for backward compatibility.