Hello,
I'm always with my access to mysql port.
I noticve that access can dispaly a â but it s like a a.
So I make this query to select some specials row from my database :
select ort from localite_ortsnamen
where ort REGEXP
^([A-Za-z]|[àâäåáãçéèêëîïíñõôöóùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß', -])+$=0;
HI,
I had an access db with some character like
(germany ä, spain ñ, scandinavia char ), it's well ordered under
access.
but my export in mysql latin1 give a wrong order.
How can I do to have a well classed db like under access (with win1250
charset I think ?, how can I make to have the