Answer
CHAR_LENGTH includes leading and trailing blanks and the string-termination character LENGTH excludes trailing blanks and the string-termination character. It does not exclude leading blanks.

NEXT>>

More MySQL Links

Describe MyISAM table.

Answer - In MySQL MyISAM is the default storage engine. MyISAM tables........
What are the Performance and Scalability characteristics of MySQL?

Answer - MySQL has a unique storage engine architecture that makes it adaptable to most.........
Explain the difference between BOOL, TINYINT and BIT.

Answer - BIT data type can store up to 8 bytes from My SQL version 5.0.3.......

Describe MySQL Connection using mysql binary.

Answer - Establishing connection to MySQL database using Mysql binary........

Today's Hot Jobs

C++ SQL Server

.NET Java Oracle

Finance Marketing

Seekers Employers

MySQL CHAR_LENGTH and LENGTH

NEXT>>

What is the difference between CHAR_LENGTH and LENGTH?

NEXT>>

Describe MyISAM table.

What are the Performance and Scalability characteristics of MySQL?

Explain the difference between BOOL, TINYINT and BIT.

Describe MySQL Connection using mysql binary.