Database collation #94

Closed
rwarasaurus opened this Issue Apr 5, 2012 · 4 comments

Comments

Projects
None yet
2 participants
@rwarasaurus
Member

rwarasaurus commented Apr 5, 2012

Add the database collation in the config for more accurate sorting.

http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-sets.html

@ghost ghost assigned rwarasaurus Apr 5, 2012

@Chrillemeter

This comment has been minimized.

Show comment Hide comment
@Chrillemeter

Chrillemeter Apr 11, 2012

Contributor

It should be higher prio on this.

When I use utf8_general_ci the database think A and Ä is the same when sorting. if I change it to utf8_swedish_ci then the sorting gets right.

Contributor

Chrillemeter commented Apr 11, 2012

It should be higher prio on this.

When I use utf8_general_ci the database think A and Ä is the same when sorting. if I change it to utf8_swedish_ci then the sorting gets right.

@rwarasaurus

This comment has been minimized.

Show comment Hide comment
@rwarasaurus

rwarasaurus Apr 11, 2012

Member

What about when you use utf8_unicode_ci ?

Member

rwarasaurus commented Apr 11, 2012

What about when you use utf8_unicode_ci ?

@Chrillemeter

This comment has been minimized.

Show comment Hide comment
@Chrillemeter

Chrillemeter Apr 11, 2012

Contributor

It's the same as with utf8_general_ci.

Ä is the same as A when you compare characters with other collations than swedish. That's why there is country specific collations.

Contributor

Chrillemeter commented Apr 11, 2012

It's the same as with utf8_general_ci.

Ä is the same as A when you compare characters with other collations than swedish. That's why there is country specific collations.

@rwarasaurus

This comment has been minimized.

Show comment Hide comment
@rwarasaurus

rwarasaurus Apr 11, 2012

Member

Yes i realise this, i was just curious to how they compared.

Member

rwarasaurus commented Apr 11, 2012

Yes i realise this, i was just curious to how they compared.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment