answersLogoWhite

0


Best Answer

Collation in MySQL Database is a set of rules used in comparisons. Because many people use MySQL with data to be stored in languages other than English, they need to select the rules of comparisons which in turn depends on the character set used for storing that data.

In MySQL, data is stored using a specific character set, which can be defind at different levels; i.e., the sever, the database, the table, and the column levels. Each character set has a default collation; for instance, the Latine1 character set uses the latin1_swedish_ci collation which is the Swedish case insensitive order. Usually, when someone develops an application that involves localization (using the local language; e.g., Arabic) or Internationalization (i.e., using multiple languages), they resort to Unicode (utf-8) which has several collations. In general, it is a good idea to set the character set to utf-8 and select the relevant collation or just accept the default utf8-general-ci.

Reference

[1] MySQL Reference, Character Sets and Collations in General. Available at http://dev.mysql.com/doc/refman/5.0/en/charset-general.html

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is collation in MySQL Database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is collation in MySQL?

Collation in MySQL Database is a set of rules used in comparisons. Because many people use MySQL with data to be stored in languages other than English, they need to select the rules of comparisons which in turn depends on the character set used for storing that data.In MySQL, data is stored using a specific character set, which can be defind at different levels; i.e., the sever, the database, the table, and the column levels. Each character set has a default collation; for instance, the Latine1 character set uses the latin1_swedish_ci collation which is the Swedish case insensitive order. Usually, when someone develops an application that involves localization (using the local language; e.g., Arabic) or Internationalization (i.e., using multiple languages), they resort to Unicode (utf-8) which has several collations. In general, it is a good idea to set the character set to utf-8 and select the relevant collation or just accept the default utf8-general-ci.Reference[1] MySQL Reference, Character Sets and Collations in General. Available at http://dev.mysql.com/doc/refman/5.0/en/charset-general.html


How do you create a new database in MySQL?

The MySQL command is "CREATE DATABASE [dbname]" with "[dbname]" replaced with your desired database name.


What type of database is used in Friendster?

MYSQL database


What is MyISAM in MySQL?

MyISAM is the default table engine in the MySQL database.


What database does the WAMP server refer to when it?

WAMP stands for Windows Apache Mysql PHP. Mysql is the default database in WAMP


What is wikipedia's database website?

Wikipedia uses MySQL as its database.


How do you copy a database of mysql in wamp server from one computer to another?

You have several options: * copy the database files from mysql/data/<database_name> to a new mysql Installation * use mysqldump utility to export the data from your database and load it into the new mysql installation * setup replication


What company is the developer of the MySQL database?

The developer of the MySQL database software was MySQL AB, which was bought by Sun 2008 for one billion dollars. Oracle then acquire sun and hence MySQL and is currently responsible for the continuing development.


How do you put today's date into MySQL database?

Use: $todaysdate = date("d/m/y"); And then just send that to the MySQL database


What are four database programs?

Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.


Why did Google change their database from Oracle to MySQL?

Google don't use Oracle or MySQL, they use their own database software known as Bigtable.


Is MySQL an open-source operating system?

No, MySQL is an open-source database system