MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Possible to print out the sort string instead of the actual string (Muenchen instead of München)?
Posted by: Torben Frey
Date: October 17, 2006 04:43AM

Hi,

I am trying to print out a field containing utf8 entries in its sort order.

This means the actual utf8 entry in the DB is
München

I would like to SELECT this in a way that I get

Munchen (when I use the collation latin1_german1_ci) or
Muenchen (when I use the collation latin1_german2_ci).

I know collations are for sorting - but is there a way to SELECT their internal coding? As far as I would say so far it is not possible, but I hope some expert knows a solution...

Thanks in advance,
Torben

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Possible to print out the sort string instead of the actual string (Muenchen instead of München)?
3606
Torben Frey
October 17, 2006 04:43AM
Re: Possible to print out the sort string instead of the actual string (Muenchen instead of München)?
1747
Peter Gulutzan
October 19, 2006 03:27PM


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.