hi, i have to sort a list of alpha-numeric data,
this is what the list should look like when i give an order command: 123a 123b 123c 123A 123B 123C but this is the result: 123a 123A 123b 123B 123C some fields he puts the capital letters first 123c How can i become the list above, i've been experimenting with starting the mysqld with the option --default-character-set=... different options but that doesn't seem to make a lot of difference? Any idea's Thanx Marco --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
