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, 3766🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How to convert a JSON (JavaScript Object Notation) quoted string into a regular character string usi...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...