I would wait until your DB is offline (such as on a weekend)
Once you find the Character Set you want e.g. greek_general_ci
http://dev.mysql.com/doc/refman/5.0/en/charset-se-me-sets.html
then alter your DB to use that character set
http://dev.mysql.com/doc/refman/5.0/en/charset-database.html
M--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.
----- Original Message -----
From: "tasos" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Wednesday, June 27, 2007 1:16 PM
Subject: greek collation & sorting
Hello people.I would like to ask the following.Using greek character set
and collation i perform a
select-order by.But i get first the latin characters and then the greek
ones.Can i show first the
greek ones and then the latin?
Thank you in advance!
ps:moreover i would like to sort them in pairs.i mean first latin a and
greek a,then b etc...is this
possible?thank you again!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]