Is there nvarchar datatype in MySql?

最新推荐文章于 2024-09-15 20:24:46 发布

zh_hui1230

最新推荐文章于 2024-09-15 20:24:46 发布

阅读量131

点赞数

分类专栏： MySql 文章标签： mysql varchar nvarchar

本文链接：https://blog.csdn.net/zh_hui1230/article/details/84223909

版权

MySql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

there is no nvarchar datatype in mysql. You have convert it to varchar.

MSSQL: nvarchar(100)
translates to
MySQL: varchar(100) character set UTF8

works as well for the text / ntext - in mysql unicode is switched on by the 'character set UTF8' option.

----

For column level you can set "character set" as follows:

create table nvarchar_test
(
_id varchar(10) character set utf8,
_name varchar(200) character set ascii
)

In the above example _id will be able to take 10 unicode characters and _name will be able to take 100 unicode characters (each unicode character will evaluate to two ascii character)