mysql equivalent data types

by

Going by http://msdn.microsoft.com/en-us/library/ms186939.aspx, I would say that

VARCHAR(n) CHARSET ucs2

is the closest equivalent. But I don’t see many people using this, more often people use:

VARCHAR(n) CHARSET utf8

As far as I am aware, both charactersets utf8 and ucs2 allow for the same characters, only the encoding is different. So either one should work, and I would probably go for the latter since it is used more often.

There are some limitations in MySQL’s unicode support that may or may not apply to your use case. Please refer to http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html for more info on MySQL’s unicode support.

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. sql query to modify the selected value from database [closed]
  3. Calculate Average of the largest values in multiple columns
  4. SQL Print the name of all Employees together with the name of their supervisor
  5. What is the size of column of int(11) in mysql in bytes?
  6. What column type/length should I use for storing a Bcrypt hashed password in a Database?
  7. What data type to use for hashed password field and what length?
  8. Does SQL Server Offer Anything Like MySQL’s ON DUPLICATE KEY UPDATE
  9. Storing JSON in database vs. having a new column for each key
  10. What is the benefit of zerofill in MySQL?
  11. MySQL LIMIT clause equivalent for SQL SERVER
  12. How to export SQL Server database to MySQL? [duplicate]
  13. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  14. The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
  15. How to transform a MSSQL CTE query to MySQL?
  16. When to use SELECT … FOR UPDATE?
  17. Best practices for SQL varchar column length [closed]
  18. Relationship between catalog, schema, user, and database instance
  19. Import MySQL database into a SQL Server
  20. MySQL Aggregate Functions without GROUP BY clause
  21. What resources exist for Database performance-tuning? [closed]
  22. How to write a (MySQL) “LIMIT” in SQL Server?
  23. sql group by versus distinct
  24. How to import a SQL Server .bak file into MySQL?
  25. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  26. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  27. What are the max number of allowable parameters per database provider type?
  28. Why in SQL NULL can’t match with NULL?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment