Re: ignore accents in order by

2009-06-12 Thread Per Jessen
PJ wrote: Let me put it this way, I am not having the problem. The problem seems to be withthe way that character encoding is set up on the internet - as confused and inconsistent as most everything else. You can put whatever charset you want in the header, in the collations in your

Re: ignore accents in order by

2009-06-12 Thread Isart Montane
I agree with Per, I use utf8 and it works fine for me, even with Chinese characters On Fri, Jun 12, 2009 at 8:40 AM, Per Jessen p...@computer.org wrote: PJ wrote: Let me put it this way, I am not having the problem. The problem seems to be withthe way that character encoding is set up on

ignore accents in order by

2009-06-11 Thread PJ
Is there a way to order lists while ignoring the accents? So far, I have found nothing simple; and I need to keep the accents for output. The language is French (and québécois) :-) TIA -- Hervé Kempf: Pour sauver la planète, sortez du capitalisme.

Re: ignore accents in order by

2009-06-11 Thread Isart Montane
Hi, I'm not having any problem on my local computer mysql select text,text2 from table1 order by text2 desc; +--+---+ | text | text2 | +--+---+ | a| 1 | | �| 0 | +--+---+ mysqlselect text,text2 from table1 order by text2 desc; +--+---+ | text |

Re: ignore accents in order by

2009-06-11 Thread PJ
Isart Montane wrote: Hi, I'm not having any problem on my local computer mysql select text,text2 from table1 order by text2 desc; +--+---+ | text | text2 | +--+---+ | a   |    1 | | �   |    0 | +--+---+ mysqlselect text,text2 from table1