cb154 Posted July 15, 2010 Share Posted July 15, 2010 Hi wasn't sure if to post here or html or mysql help but got to start somewhere. I have a table with some words contain the french acute I also have another table with words in normal UK english so for example 1 table will have Château Haut-Bages-Libéral but the other table will have Chateau Haut Bages Liberal. I am trying to perform a query from one to the other however and quite rightly it fails. is there a way of normailising the french type to enable the query to work ? Quote Link to comment Share on other sites More sharing options...
radar Posted July 15, 2010 Share Posted July 15, 2010 http://php.net/manual/en/normalizer.normalize.php may be what your looking for? Quote Link to comment Share on other sites More sharing options...
cb154 Posted July 15, 2010 Author Share Posted July 15, 2010 many thanks. been struggling to find a solution to this !! Quote Link to comment Share on other sites More sharing options...
cb154 Posted July 15, 2010 Author Share Posted July 15, 2010 I am assuming there is a class I need to include in order to access the Normalizer ? Sorry never come across this function so unsure how I utilise it ? I f i just have the code Normalizer::normalize ( string $input [, string $form = Normalizer::FORM_C ] ) I get unknown class Normalizer Quote Link to comment Share on other sites More sharing options...
radar Posted July 15, 2010 Share Posted July 15, 2010 Yeah I'm not sure ive never used it either. though upon further inspection there is a class: http://www.php.net/manual/en/class.normalizer.php as far as how to include it, or utilize it i have no clue. Quote Link to comment Share on other sites More sharing options...
cb154 Posted July 15, 2010 Author Share Posted July 15, 2010 have a feeling this might end up with me writing my own ! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.