Data type: Difference between revisions

Data type (edit)

311 bytes added , 25 June 2013

14,958

edits

@@ Line 60: / Line 60: @@
 == comparision of datatypes in different database server ==
-DATETIME: ex: "2013-06-13 03:33:33" MS SQL 2008, MySQL is equivalent
+Storing Unicode text
+* MySQL: {{kbd | key=varchar}}
+* MS SQL 2008: {{kbd | key=nvarchar}}<ref>[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>
-TIMESTAMP: MS SQL 2008 and MySQL is '''NOT''' equivalent<ref>[http://stackoverflow.com/questions/8665548/sql-server-2008-timestamp-data-type SQL Server 2008 timestamp data type - Stack Overflow]</ref> {{exclaim}}
+{{kbd | key=DATETIME}}: ex: "2013-06-13 03:33:33"
+* MS SQL 2008, MySQL is equivalent
+{{kbd | key=TIMESTAMP}}: MS SQL 2008 and MySQL is '''NOT''' equivalent<ref>[http://stackoverflow.com/questions/8665548/sql-server-2008-timestamp-data-type SQL Server 2008 timestamp data type - Stack Overflow]</ref> {{exclaim}}
 * MS SQL 2008<ref>[http://msdn.microsoft.com/en-us/library/ms182776(v=sql.90).aspx timestamp (Transact-SQL)]</ref> ex: 0x00000000000007D3
 * MySQL ex: 2013-06-13 03:33:33