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

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

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

Use of meta tags

Metatags and Their Uses A brief description of each of the basic meta tags followed by an example: Title   The title of the web page is perhaps the most important of all meta tags <title>Clickfire - Viewpoints, Tools, and Content for Webmasters</title> Keywords    Keywords should be separated by commas, with the more important words listed first. Note: Inktomi (acquired by Yahoo!) was said to be the only major search engine that using the keywords meta tag to index sites. <meta name="keywords" content="free, webmaster, resources, articles, tools, tutorials, reviews, graphics, scripts, download, CIW, freeware"> Description   <meta name="description" content="Clickfire empowers webmasters by offering free resources like graphics, articles, news, reviews, freeware, tutorials, scripts, wallpaper, backgrounds, Metty meta tag maker, icons, CIW ...
Post a Comment
Read more