Sponsored Links
- Nov 22 Wed 2017 11:47
[資料庫管理工具] Navicat Premium Portable 12.0.17、Navicat Premium Portable 12
- Nov 15 Wed 2017 21:01
[圖形工具] Adobe illustrator CC 2018 x64、Adobe illustrator CC x64、illustrator CC 2018 x64
- Nov 11 Sat 2017 21:20
[SQL][SERVER] Microsoft SQL Server Management Studio 顯示行號
- Nov 09 Thu 2017 14:58
[圖形工具] Adobe illustrator CC 2017 x86、Adobe illustrator CC x86、illustrator CC 2017 x86
- Nov 03 Fri 2017 21:32
[圖形工具] Adobe illustrator CC 2017 x64、Adobe illustrator CC x64、illustrator CC 2017 x64
- Oct 28 Sat 2017 20:46
[密碼破解] Daossoft ZIP Password rescuer Version 7.0.0.1、Daossoft ZIP Password rescuer Crack
- Oct 28 Sat 2017 16:24
[Windows] How to Install XAMPP Apache + MariaDB + PHP + Perl on Windows 10
- Oct 28 Sat 2017 12:22
[MySQL] MySQL to SQL Server Data Type Comparisons
Overview
Unfortunately MySQL and MS SQL Server use slightly different data types, so you will have to do some
- Oct 28 Sat 2017 12:07
[SQL][SERVER] Microsoft SQL Server Type Mapping
Table 10.2 Type 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 Server 5.5 and above can have CHAR columns with a length up to 255 characters. Anything larger is migrated as LONGTEXT |
| NCHAR | CHAR/LONGTEXT | Depending 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. |
| VARCHAR | VARCHAR/MEDIUMTEXT/LONGTEXT | Depending 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. |
| NVARCHAR | VARCHAR/MEDIUMTEXT/LONGTEXT | Depending 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. |
| DATE | DATE | |
| DATETIME | DATETIME | |
| DATETIME2 | DATETIME | Date 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 |
| SMALLDATETIME | DATETIME | |
| DATETIMEOFFSET | DATETIME | |
| TIME | TIME | |
| TIMESTAMP | TIMESTAMP | |
| ROWVERSION | TIMESTAMP | |
| BINARY | BINARY/MEDIUMBLOB/LONGBLOB | Depending on its length |
| VARBINARY | VARBINARY/MEDIUMBLOB/LONGBLOB | Depending on its length |
| TEXT | VARCHAR/MEDIUMTEXT/LONGTEXT | Depending on its length |
| NTEXT | VARCHAR/MEDIUMTEXT/LONGTEXT | Depending on its length |
| IMAGE | TINYBLOB/MEDIUMBLOB/LONGBLOB | Depending on its length |
| SQL_VARIANT | not migrated | There is not specific support for this datatype. |
| TABLE | not migrated | There is not specific support for this datatype. |
| HIERARCHYID | not migrated | There is not specific support for this datatype. |
| UNIQUEIDENTIFIER | VARCHAR(64) | A unique flag set in MySQL. There is not specific support for inserting unique identifier values. |
| SYSNAME | VARCHAR(160) | |
| XML | TEXT |
- Oct 15 Sun 2017 21:25
[Windows] 如何刪除 Windows 7, 8 , 10 , Vista or XP 服務(Service)、How to Delete a Windows Service in Windows 7, 8, 10, Vista, or XP
If you are a fan of tweaking your system and disabling services, you might find that over time your
Windows Services list becomes large and unwieldy.
- Oct 14 Sat 2017 15:25
[VMWare] 如何讓 VMWare 能安裝 MAC OS、MAC OS X 作業系統、Mac OS X Unlocker for VMware V2.0
Mac OS X Unlocker for VMware V2.0
- Oct 10 Tue 2017 15:25
[Chrome] OneTab 備份、OneTab 紀錄路徑
Chrome 套件 OneTab 儲存記錄放在哪？
C:\Users\UserName\AppData\Local\Google\Chrome\User Data\Default\Local Storage\
- Oct 09 Mon 2017 19:28
刪除 Yahoo 帳號、刪除 Yahoo mail
- Oct 08 Sun 2017 16:42
[Windows 10] Windows 10 Fn 鍵失效、升級 Windows 10 之後 Fn 快捷鍵失效、Windows 10 Fn 鍵無作用
最近因 Windows 10 作業系統出了問題，將系統重新安裝，後來發現電腦上的 F1 到 F12 等按鍵做組合使用 Fn 快速功能
鍵失效；突然不能調整亮度、音量，用起來真是不大方便。
汽車、機車 (2)
