Converting chararacters greater ASCII 122 (não -> nao)

2003-11-05 Thread Al Bogner
I have to convert names with characters greater than ASCII 122 - z to use it in a select statement: Is there a way to do it, like select field, function(field) as converted Examples: não -> nao você -> voce cabeça -> cabeca É Possibile -> E Possibile N` Aniré -> N Anire Sé Mañana -> Se Man

Viruses from the list

2003-11-05 Thread Al Bogner
I use an email-adress for this list only and since my first posting a few days ago I got viruses, while I didn't before. VIRUS FROM mamo @ hvd.healthnet.lu (W32/[EMAIL PROTECTED]) VIRUS FROM kawamoto @ wave.tky.plala.or.jp ([EMAIL PROTECTED]) VIRUS FROM sales @ vulcanford.ca (W32/[EMAIL PROTECTED

mysqldump sorted

2003-11-04 Thread Al Bogner
Is it possible to sort the records, which are created with mysqldump? I didn't find an optioin in man mysqldump. If you cannot do it with mysqldump, what would be the best workaroud for it? into outfile? Al -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs