String types


show more String types provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training show less
please wait ...

String types

MySQL provides string types for a variety of purposes. Character strings are used to store text based strings. Binary strings store non-text based data. Fixed length strings are padded and always use the same amount of storage. Variable length strings use less storage when the strings are shorter, and large object storage is used for storing documents and media files. Character strings come in two varieties. The CHAR string is a fixed length string.

The parameters used to define the length of the string. For example, if you specify a length of 5, the string will alway be 5 characters in length. If you put fewer than 5 characters in the string, it will add spaces at the end of the string in order to pad it out to 5 characters, and when you retrieve the string from the table, any padded spaces are removed first. The VARCHAR string is variable in length. The parameter is used to limit the length of the string. For example, if you specify a length of 25, the string will have up to 25 characters, plus the 1 ...

String types
Video duration: 2m 58s 4h 24m Beginner

Viewers:

String types provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training

Subject:
Developer
Software:
MySQL
Author:
please wait ...