{"id":368,"date":"2016-03-31T20:27:25","date_gmt":"2016-03-31T11:27:25","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=368"},"modified":"2016-03-31T20:28:08","modified_gmt":"2016-03-31T11:28:08","slug":"microsoft-sql-server-type-mapping","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2016\/03\/31\/microsoft-sql-server-type-mapping\/","title":{"rendered":"Microsoft SQL Server Type Mapping"},"content":{"rendered":"
\n
\n
\n

10.5.4\u00a0Microsoft SQL Server Type Mapping<\/h3>\n<\/div>\n<\/div>\n<\/div>\n
\n

<\/a><\/p>\n

Table\u00a010.2\u00a0Type mapping<\/b><\/p>\n

\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Source Type<\/th>\nMySQL Type<\/a><\/th>\nComment<\/th>\n<\/tr>\n<\/thead>\n
INT<\/td>\nINT<\/td>\n<\/td>\n<\/tr>\n
TINYINT<\/td>\nTINYINT<\/td>\nUNSIGNED flag set in MySQL<\/td>\n<\/tr>\n
SMALLINT<\/td>\nSMALLINT<\/td>\n<\/td>\n<\/tr>\n
BIGINT<\/td>\nBIGINT<\/td>\n<\/td>\n<\/tr>\n
BIT<\/td>\nTINYINT(1)<\/td>\n<\/td>\n<\/tr>\n
FLOAT<\/td>\nFLOAT<\/td>\nPrecision value is used for storage size in both<\/td>\n<\/tr>\n
REAL<\/td>\nFLOAT<\/td>\n<\/td>\n<\/tr>\n
NUMERIC<\/td>\nDECIMAL<\/td>\n<\/td>\n<\/tr>\n
DECIMAL<\/td>\nDECIMAL<\/td>\n<\/td>\n<\/tr>\n
MONEY<\/td>\nDECIMAL<\/td>\n<\/td>\n<\/tr>\n
SMALLMONEY<\/td>\nDECIMAL<\/td>\n<\/td>\n<\/tr>\n
CHAR<\/td>\nCHAR\/LONGTEXT<\/td>\nDepending on its length. MySQL Server 5.5 and above can have CHAR columns with a length up to 255 characters. Anything larger is migrated as LONGTEXT<\/td>\n<\/tr>\n
NCHAR<\/td>\nCHAR\/LONGTEXT<\/td>\nDepending on its length. MySQL Server 5.5 and above can have VARCHAR columns with a length up to 65535 characters. Anything larger is migrated to one of the TEXT blob types. In MySQL, character set of strings depend on the column character set instead of the datatype.<\/td>\n<\/tr>\n
VARCHAR<\/td>\nVARCHAR\/MEDIUMTEXT\/LONGTEXT<\/td>\nDepending on its length. MySQL Server 5.5 and above can have VARCHAR columns with a length up to 65535 characters. Anything larger is migrated to one of the TEXT blob types.<\/td>\n<\/tr>\n
NVARCHAR<\/td>\nVARCHAR\/MEDIUMTEXT\/LONGTEXT<\/td>\nDepending on its length. MySQL Server 5.5 and above can have VARCHAR columns with a length up to 65535 characters. Anything larger is migrated to one of the TEXT blob types. In MySQL, character set of strings depend on the column character set instead of the datatype.<\/td>\n<\/tr>\n
DATE<\/td>\nDATE<\/td>\n<\/td>\n<\/tr>\n
DATETIME<\/td>\nDATETIME<\/td>\n<\/td>\n<\/tr>\n
DATETIME2<\/td>\nDATETIME<\/td>\nDate range in MySQL is ‘1000-01-01 00:00:00.000000’ to ‘9999-12-31 23:59:59.999999’. Note: fractional second values are only stored as of MySQL Server 5.6.4<\/td>\n<\/tr>\n
SMALLDATETIME<\/td>\nDATETIME<\/td>\n<\/td>\n<\/tr>\n
DATETIMEOFFSET<\/td>\nDATETIME<\/td>\n<\/td>\n<\/tr>\n
TIME<\/td>\nTIME<\/td>\n<\/td>\n<\/tr>\n
TIMESTAMP<\/td>\nTIMESTAMP<\/td>\n<\/td>\n<\/tr>\n
ROWVERSION<\/td>\nTIMESTAMP<\/td>\n<\/td>\n<\/tr>\n
BINARY<\/td>\nBINARY\/MEDIUMBLOB\/LONGBLOB<\/td>\nDepending on its length<\/td>\n<\/tr>\n
VARBINARY<\/td>\nVARBINARY\/MEDIUMBLOB\/LONGBLOB<\/td>\nDepending on its length<\/td>\n<\/tr>\n
TEXT<\/td>\nVARCHAR\/MEDIUMTEXT\/LONGTEXT<\/td>\nDepending on its length<\/td>\n<\/tr>\n
NTEXT<\/td>\nVARCHAR\/MEDIUMTEXT\/LONGTEXT<\/td>\nDepending on its length<\/td>\n<\/tr>\n
IMAGE<\/td>\nTINYBLOB\/MEDIUMBLOB\/LONGBLOB<\/td>\nDepending on its length<\/td>\n<\/tr>\n
SQL_VARIANT<\/td>\nnot migrated<\/td>\nThere is not specific support for this datatype.<\/td>\n<\/tr>\n
TABLE<\/td>\nnot migrated<\/td>\nThere is not specific support for this datatype.<\/td>\n<\/tr>\n
HIERARCHYID<\/td>\nnot migrated<\/td>\nThere is not specific support for this datatype.<\/td>\n<\/tr>\n
UNIQUEIDENTIFIER<\/td>\nVARCHAR(64)<\/td>\nA unique flag set in MySQL. There is not specific support for inserting unique identifier values.<\/td>\n<\/tr>\n
SYSNAME<\/td>\nVARCHAR(160)<\/td>\n<\/td>\n<\/tr>\n
XML<\/td>\nTEXT<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n\n\n\n
Source Type<\/th>\nMySQL Type<\/a><\/th>\nComment<\/th>\n<\/tr>\n<\/thead>\n<\/table>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

10.5.4\u00a0Microsoft SQL Server Type Mapping Table\u00a010.2\u00a0Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL SMALLINT SMALLINT BIGINT BIGINT BIT TINYINT(1) FLOAT FLOAT Precision value is used for storage size in both REAL FLOAT NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL SMALLMONEY DECIMAL CHAR CHAR\/LONGTEXT Depending on its length. MySQL […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,5],"tags":[],"class_list":["post-368","post","type-post","status-publish","format-standard","hentry","category-mariadb-mysql","category-mssql"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=368"}],"version-history":[{"count":2,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/368\/revisions"}],"predecessor-version":[{"id":370,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/368\/revisions\/370"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}