Skip to main content

What is collation in MySQL Database?

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.
Labels:

Comments

Post a Comment

Popular posts from this blog

Number Format In Javascript

Number.toFixed() :                                 Formats any number for "x" number of trailing decimals. The number is rounded up, and "0"s are used after the decimal point if needed to create the desired decimal length.   var profits=2489.8237 profits.toFixed(3) //returns 2489.824 (round up) profits.toFixed(2) //returns 2489.82 profits.toFixed(7) //returns 2489.8237000 (padding)   Number.toPrecision() :                                   Formats any number so it is of "x" length. Also called significant digits. A decimal point and "0"s are used if needed to create the desired length.   var anumber=123.45 anumber.toPreci...
2 comments
Read more

Disable right click

Hello there Sometimes we want to disable right click in our webpage for security reason. That we can do with the use of javascript. here is the code     <SCRIPT TYPE="text/javascript">             var message="Sorry, right-click has been disabled";                         function clickIE() {                 if (document.all) {                     (message);                     return false;                 }             }             function clickNS(e) {  ...
Post a Comment
Read more

Difference between == and === in php

Two of the many comparison operators used by PHP are '==' (i.e. equal) and '===' (i.e. identical). The difference between the two is that '==' should be used to check if the values of the two operands are equal or not. On the other hand, '===' checks the values as well as the type of operands. Let me explain more using some examples: '==' (Equal): if("22" == 22) echo "YES"; else echo "NO";      The code above will print "YES". The reason is that the values of the operands are equal. Whereas when we run the example code below: '===' (Identical): if("22" === 22) echo "YES"; else echo "NO"; The result we get is "NO". The reason is that although values of both operands are same their types are different, "22" (with quotes) is a string while 22 (w/o quotes) is an integer. But if we change the code above to t...
Post a Comment
Read more