a select n a regexp expression

2001-11-21 Thread David Devidal
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;

pb with different charset of latin1

2001-11-20 Thread David Devidal
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