Microsoft SQL中的MySQL长文本模拟? [英] MySQL longtext analogue in Microsoft SQL?
问题描述
我是Microsoft SQL的新手,我正尝试从MySQL导入数据库.我唯一遇到的问题是MySQL数据库对几个表列使用longtext
数据类型.
哪种Microsoft SQL数据类型类似于MySQL longtext
?
谢谢您的时间.
Microsoft SQL Server具有非常相似的NTEXT
和NVARCHAR(MAX)
.相对于早期的NTEXT
(如果不需要存储除单个代码页以外的任何内容,则再次推荐TEXT
),建议使用NVARCHAR(MAX)
(如果不需要处理国际化,则建议使用VARCHAR(MAX)
.)>
I am new to Microsoft SQL, and I am attempting to import a database from MySQL. The only issue that I am having is that the MySQL database uses the longtext
data type for several table columns.
What Microsoft SQL datatype is analogous to MySQL longtext
?
Thank you for your time.
Microsoft SQL Server has NTEXT
and NVARCHAR(MAX)
which are both very similar; NVARCHAR(MAX)
(or VARCHAR(MAX)
if you don't need to handle internationalisation) is recommended over the earlier NTEXT
(and TEXT
again if you don't need to store anything other than a single codepage.)
这篇关于Microsoft SQL中的MySQL长文本模拟?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!