How to Add a Collation
Contents |
← Back to MySQL University main page
[edit] How to Add a Collation
- Date: 2007-09-21
- Presenter: Alexander Barkov
- Scribe: Paul DuBois
- Attendees (please register by filling in your name below, and read the Instructions for Attendees):
- KishoreKumar Bairi
- M G
- ...
Special Note
This is an IRC-only session in question-and-answer format (no need to connect to voice streaming).
Please review the presentation slides prior to attending, and be ready to ask your questions during the session. Or better yet, enter your questions into the session page below so that our presenter can see them ahead of time and know what you're interested in! Thanks.
[edit] Presentation
[edit] Questions
[edit] Questions asked before the session
- What is a Collation?
- Collation is a set of rules determining how to compare and sort character data. Collation properties include things like case sensitivity, accent sensitivity, trailing spaces sensitivity, and others. In MySQL, every CHAR, VARCHAR, TEXT column have some collation assumption.
- How does installing a collation affect localisation of my DB?
- Can you rephrase the question please?
- ...
- ...
[edit] Questions asked during the session
- There was a question on the mysql@ mailing list the other day where a guy wanted ORDER BY to compare various a and a-with-accent characters the same, but for WHERE col = 'a' to select *only* 'a' and not the a-with-accent characters. I didn't think that made sense, but is it possible with our current collations, or any collation?
- FIRST_ANSWER
- SECOND_QUESTION
- SECOND_ANSWER
- ...
- ...
[edit] Voice recording and other links
- Voice Recording: none
- IRC log: IRC Text (9KB)
- Other resources:
- Collation-Charts.org: http://www.collation-charts.org/