Matt, you're right--re mb_* fund should be used, or you could mangle multibyte chars.
-ed

Sent from my drmPhone

On Nov 17, 2008, at 7:41 AM, "Matt Sanford" <[EMAIL PROTECTED]> wrote:



On Mon, Nov 17, 2008 at 7:17 AM, fastest963 <[EMAIL PROTECTED]> wrote:


Another note: md5 is case-sensitive! If using indexes as I have stated
above and using tables with md5 first letter, then remember to do
strtolower() for indexes and before doing md5!

Great optimizations, I especially like the sharding/partitioning. As a Unicode geek I feel compelled to mention: I'm not sure PHP strtolower is safe for multi-byte UTF-8. I'm quite sure it's not safe in Ruby (you have to use string.chars.downcase). My PHP is very rusty but I think the (slower) mb_strtolower is multi-byte character safe. I don't think this affects the code you're using, but it's always worth mentioning.

— Matt

Reply via email to