Collections:
Difference between CHAR and NCHAR in MySQL
What Are the Differences between CHAR and NCHAR in MySQL?
✍: FYIcenter.com
Both CHAR and NCHAR are fixed length string data types. But they have the following differences:
The following column definitions are the same:
CREATE TABLE faq (Title NCHAR(80)); CREATE TABLE faq (Title NATIONAL CHAR(80)); CREATE TABLE faq (Title NATIONAL CHARACTER(80)); CREATE TABLE faq (Title CHAR(80) CHARACTER SET utf8); CREATE TABLE faq (Title CHARACTER(80) CHARACTER SET utf8);
⇒ Difference between CHAR and VARCHAR in MySQL
⇐ Character String Data Types in MySQL
2018-01-19, 1746🔥, 0💬
Popular Posts:
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...