What Are the Differences between CHAR and NCHAR

Home > MySQL > SQL

Q

What Are the Differences between CHAR and NCHAR? - MySQL FAQs - Introduction to SQL Basics

✍: FYIcenter.com

A

Both CHAR and NCHAR are fixed length string data types. But they have the following differences:

CHAR's full name is CHARACTER.
NCHAR's full name is NATIONAL CHARACTER.
By default, CHAR uses ASCII character set. So 1 character is always stored as 1 byte.
By default, NCHAR uses Unicode character set. NCHAR data are stored in UTF8 format. So 1 character could be stored as 1 byte or upto 4 bytes.
Both CHAR and NCHAR columns are defined with fixed lengths in units of characters.

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);

2007-05-11, 4813👍, 0💬

💬 2016-11-09 lux: good

What Are Numeric Data Types
What Are Numeric Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following numeric data types: BIT(n) - An integer with n bits. BOOL same as BOOLEAN - Boolean values stored in 1 bit. TINYINT - A small integer stored in 1 byte. SMALLINT - A small integer stored in 2 bytes. ME... 2007-05-11, 4882👍, 0💬

How To Run MySQL Server on a Different Port
How To Run MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration By default, MySQL will listen at port number 3306 for any client connections. But you can change this by starting the server with "--port=portNumber" option. The tutorial exercise shows you how to start t... 2007-05-11, 4849👍, 0💬

What Are the Differences between CHAR and VARCHAR
What Are the Differences between CHAR and VARCHAR? - MySQL FAQs - Introduction to SQL Basics CHAR and VARCHAR are both ASCII character data types by default. But they have the following major differences: CHAR stores values in fixed lengths. Values are padded with space characters to match the speci... 2007-05-11, 4829👍, 0💬

What Are the Differences between CHAR and NCHAR
What Are the Differences between CHAR and NCHAR? - MySQL FAQs - Introduction to SQL Basics Both CHAR and NCHAR are fixed length string data types. But they have the following differences: CHAR's full name is CHARACTER. NCHAR's full name is NATIONAL CHARACTER. By default, CHAR uses ASCII character se... 2007-05-11, 4814👍, 0💬

What Are the Differences between BINARY and VARBINARY
What Are the Differences between BINARY and VARBINARY? - MySQL FAQs - Introduction to SQL Basics Both BINARY and VARBINARY are both binary byte data types. But they have the following major differences: BINARY stores values in fixed lengths. Values are padded with 0x00. VARBINARY stores values in va... 2007-05-11, 4773👍, 0💬

How To Connect to MySQL Server on a Different Port
How To Connect to MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration If your MySQL server is listening on port number different than 3306, you need to specify "--port=portNumber" option to any client program that needs to connect to the server. The tutorial exercise... 2007-05-11, 4705👍, 0💬

What Are Date and Time Data Types
What Are Date and Time Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following date and time data types: DATE - A date in the range of '1000-01-01' and '9999-12-31'. Default DATE format is "YYYY-MM-DD". DATETIME - A date with the time of day in the range of '1000-01-01 00:... 2007-05-11, 4687👍, 0💬

What Are String Data Types
What Are String Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following string data types: CHAR(n) same as CHARACTER(n) - Fixed width and " " padded characters strings. Default character set is ASCII. NCHAR(n) same as NATIONAL CHARACTER(n) - Fixed width and " " padded char... 2007-05-11, 4631👍, 0💬

How Many Groups of Data Types
How Many Groups of Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL support 3 groups of data types as listed below: String Data Types - CHAR, NCHAR, VARCHAR, NVARCHAR, BINARY, VARBINARY, TINYBLOB, TINYTEXT, BLOB, TEXT, MEDIUMBLOB, MEDIUMTEXT, LONGBLOB, LONGTEXT, ENUM, SET Numeric Data Typ... 2007-05-11, 4568👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.