nezbie Posted February 27, 2006 Share Posted February 27, 2006 Hi, I'm having some trouble pulling data from mysql via a php search script.. Shortly, in mysql, scandinavian special characters are saved by fckeditor (a wysiwyg editor) like this:ä = äö = öNow, when entering a search phrase to a field on my page, ofcourse I would enter something like "öland".. But when the database states this as öland, it doesn't match and no results are found.So, simply - how to change the special characters in my search string into these "umlauts" "on fly"? - I looked at the manual and came to the conclusion and after testing, that htmlentities or such won't/wouldn't help?Or am I completely wrong..?thanx in advance Quote Link to comment https://forums.phpfreaks.com/topic/3712-problem-with-special-characters-umlauts-pulling-from-mysql/ Share on other sites More sharing options...
hitman6003 Posted February 28, 2006 Share Posted February 28, 2006 [code]$text = str_replace("ö", "ö", $text);[/code]Where $text is the text that contains the characters. Quote Link to comment https://forums.phpfreaks.com/topic/3712-problem-with-special-characters-umlauts-pulling-from-mysql/#findComment-12895 Share on other sites More sharing options...
ToonMariner Posted February 28, 2006 Share Posted February 28, 2006 have a look at this[a href=\"http://uk.php.net/manual/en/function.get-html-translation-table.php\" target=\"_blank\"]php html translation table[/a] Quote Link to comment https://forums.phpfreaks.com/topic/3712-problem-with-special-characters-umlauts-pulling-from-mysql/#findComment-12897 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.