CODEWITHSUNDEEP
mysqlsql
Phạm Tiến Hải
Phạm Tiến Hải

Reputation: 23

What is the difference between varchar and nvarchar with the same character set and collation in mysql

Can anyone tell me what is the difference between varchar and nvarchar with the same character set and collate. Example:

varchar CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

and

nvarchar CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

Thank you!

Upvotes: 0

Views: 388

Answers (1)

Sujit Sharma
Sujit Sharma

Reputation: 130

Actually, MySQL do not have nvarchar() data types Click here for details

varchar() and nvarchar() are data types of sql-server and the difference is nvarchar support and unicode character mainly use for internationalisation but varchar() do not support unicode. details for sql-server nvarchar

Upvotes: -1

Related Questions