[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: greek collation & sorting
From:       tasos <tasoss () gmail ! com>
Date:       2007-06-27 19:56:22
Message-ID: 4682C0E6.9000502 () gmail ! com
[Download RAW message or body]

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" <tasoss@gmail.com> 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/mysql?unsub=mgainty@hotmail.com
>> 
>> 
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]