Question about collation
Posted 24 March 2006 - 06:48 PM
Posted 24 March 2006 - 09:34 PM
The collation will take care of things like comparing strings (including sorting them), but you'll still have to have the appropriate character set support in PHP (set the collation to make comparisons work, use the multi-byte string functions like mb_substr()), and on the client's browser (usually you can assume they've configured their browser to support their native language, but you have to tell the browser what you're sending it).
There are several more considerations, but I am not too familiar with it in practice, I've never done it myself.
Posted 24 March 2006 - 10:16 PM
I wondering more about this because I am planning to program my own CMS (to learn more about php+mysql). I just don't want to go back and mess with it or start from scratch again.
I also did some thinking and there would be a problem if I use utf-8 in the database. Like for username there is an ascii letter 'a' but there is also an unicode letter 'a' which would be a problem.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users