Sunday 15 August 2010

database - Case insensitivity for DB Collation - does it affect performance? -


Before I was working on my database, I wonder if utf8_bin Performance on case insensitive fusion such as utf8_general_ci (eg from MySQL) will increase.

Do anyone have any comments on this? What about other databases other than MySQL?

Yes, a binary collation will be faster when others

Easy to deal with a binary type or comparison case ( + Extant, kinetipe and width in SQL Server). >

No comments:

Post a Comment