Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

COLLATE and mysql 4.0.18 ?

Status
Not open for further replies.
mediaocean

mediaocean

Programmer
Dec 19, 2004
1
AT
Does anybody know a way to simulate "COLLATE" on mysql 4.0.18 ?

This would be for the ordered ouptut of a database with German terms.

Now, with latin1 it's:
a -> u -> z -> ü.

but correctly with german charset it should be:
a -> u -> ü -> z

I know that with the right character set this wouldn't be a problem, but unfortunately it's not possible to change the server settings from latin1 to latin_de.

Thanks for any help !
 
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
357
EdZzy
E
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
584
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
515
Chris Miller
Chris Miller
penguinspeaks
  • Locked
  • Question
Stored Procedures and triggers
Replies
9
Views
571
penguinspeaks
penguinspeaks
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
440
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top