14,958
edits
Data type: Difference between revisions
Jump to navigation
Jump to search
→comparision of datatypes in different database server
| Line 60: | Line 60: | ||
== comparision of datatypes in different database server == | == comparision of datatypes in different database server == | ||
Storing Unicode text | Storing Unicode text<ref>* [http://trufflepenne.blogspot.tw/2012/10/mysql-sqlservernvarchar.html 松露筆管麵: Mysql 等同SqlServer的nvarchar] | ||
* [http://stackoverflow.com/questions/144283/what-is-the-difference-between-varchar-and-nvarchar sql server - What is the difference between varchar and nvarchar? - Stack Overflow]</ref> | |||
* MySQL: {{kbd | key=varchar}} | * MySQL: {{kbd | key=varchar}} | ||
* MS SQL 2008: {{kbd | key=nvarchar}} | * MS SQL 2008: {{kbd | key=nvarchar}} | ||
{{kbd | key=DATETIME}}: ex: "2013-06-13 03:33:33" | {{kbd | key=DATETIME}}: ex: "2013-06-13 03:33:33" | ||