What is the difference between varchar and nvarchar with the same character set and collation in mys-CodePudding

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!

CodePudding user response：

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