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 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. 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] 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
Archived
This topic is now archived and is closed to further replies.