Performance issues using different collations on one column?
Posted by: Håkan Askengren
Date: March 17, 2008 12:41AM

Default collation can be set on columns in MySQL and I wonder how a specific collation is used on an index.

I have a table t1 with character set utf8, using default collation utf8_unicode_ci.
A varchar(50) column c1 in t1 has also collation utf8_unicode_ci.

But each record in c1 can consist of data in different languages: English, Swedish, German, Polish etc.
So setting the collation can not be set at application level, but must be done in runtime for each sql, switching from for example utf8_swedish_ci to utf8_unicode_ci, (using SET NAMES xx COLLATE xx).

When creating an index on column c1: is the index created using a specific collation? I wonder if there are any performance issues switching between different collations at runtime?

Håkan

Options: ReplyQuote


Subject
Views
Written By
Posted
Performance issues using different collations on one column?
5360
March 17, 2008 12:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.