Hello sir and thanks for replying.
I'm have tried all greek collations.The fact is that when sorting i see first
the latin
characters(sorted) and then the greek ones(again sorted).I want to have a
choice.I mean i want to
see first the A latin and then the greek A.Then B latin and B greek etc.Or
maybe i want the greek
characters to be shown(sorted) first and then the latin ones.Is something like
that possible.Because
i think with the current 2 greek collations this isn't possible.
Thanks once more!
Martin Gainty wrote:
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]
