Re: a select n a regexp expression

thanks to you i notice a well algo ... for regex when i put [*! * is not interpreted as a special car ! wouah select ort from localite_ortsnamen where ort REGEXP "^([A-Za-z]|[0-9]|[*!æàâäåáãçéèêëîïìíñõôöòóøùúûüÿÅÅÀÂÄÇÉÈÊËÎÏÑÔÖÛÜß&\\'\\>\\ (\\)\\,\\//\\. -])+$"; - Original Message - F

a select n a regexp expression

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; I

pb with different charset of latin1

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 c