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 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 the internet
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 data
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 |
> +--+---+
>
> mysql>select text,text2
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 |
+--+---+
mysql>select text,text2 from table1 order by text2 desc;
+--+---+
| text | t
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."
---
