Forum Moderators: phranque

Message Too Old, No Replies

What will collation influence on server and website?

         

toplisek

8:43 am on Apr 28, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



What will collation influence on server and website?

There are example some defined variables like:
1. MySQL connection collation like:
utf8_unicode_ci

2. MySQL code table like:
UTF-8 Unicode (utf8)

3. Rules of sorting like:
utf8_unicode_ci

What will exact influence these 3 points?
I mean in real communication path (server and client PC or browser)?

jdMorgan

4:49 pm on Apr 28, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



This doesn't appear to have anything to do with the communication path, but rather with searching and sorting within mySQL databases.

See this previous thread [webmasterworld.com].

Jim

g1smd

7:16 pm on Apr 28, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



I always thought that mySQL was broken when I see my database collation set to "Swedish".

It took a while to discover that the default is exactly right, and gives the right sort order for a number of European languages - English included.

toplisek

7:26 am on Apr 29, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



What is the default?(is exactly right)

jdMorgan

6:41 pm on Apr 29, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



You will likely get more/faster/better answers >here [webmasterworld.com]<.

Jim