The CHAR data type is a fixed-length character data type that can store up to 255 characters. : Char « Data Type « SQL / MySQL






The CHAR data type is a fixed-length character data type that can store up to 255 characters.

      
mysql>
The <length> placeholder specifies the number of characters stored.
mysql>
mysql>
mysql> CREATE TABLE Catalog
    -> (
    ->     ProductID SMALLINT,
    ->     Description VARCHAR(40),
    ->     Category CHAR(3),
    ->     Price DECIMAL(7,2)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table Catalog;
Query OK, 0 rows affected (0.00 sec)

mysql>

   
    
    
    
    
    
  








Related examples in the same category

1.CHAR(n): character string with specified length
2.Quoting a string value
3.Add zero to the values to force a string-to-number conversion
4.Writing Strings That Include Quotes or Special Characters
5.To include a quote character within a string that is quoted by the same kind of quote,
6.Testing String Equality or Relative Ordering
7.To find out whether a string lies within a given range of values (inclusive)
8.If you are comparing strings and numerics, or floating-point numbers and integers, MySQL will compare them as
9.Not equal char type value
10.Max with char type values
11.Compare char type value
12.Not null char type column