MySQL - Differentiate between CHAR and NCHAR.

Differentiate between CHAR and NCHAR.

CHAR is commonly referred to as character while NCHAR is referred to as NATIONAL CHARACTER. CHAR uses ASCII as its default character set. This makes one character to be stored as one byte. On the other hand, VARCHAR uses Unicode. This makes one character to be stored as one byte up to 4 bytes.
MySQL - What are date and time data types supported in MySQL?
What are date and time data types supported in MySQL? - MySQL supports the following date and time data types......
MySQL - IN Conditions and LIKE Conditions in MySQL
IN Conditions and LIKE Conditions in MySQL - IN condition is used to match specified values in a query......
MySQL - Regular expression pattern condition: REGEXP in MySQL
Regular expression pattern condition: REGEXP in MySQL - REGEXP is used to match a string against a specified pattern. There are different operators used to match patterns......
Post your comment

Related Content

Follow us

▲