ä, ö, ü doesn't work in components search module - advanced search is working proper

[kjelstrup]

Hi there

Special letters like ä, ö, ü from the german language won't be searchable in the searchposition of the compnent. If i go to advanced search it works fine and shows the correct language? Which parameters do I have to change for this? Anyone has an idea? Maybe a charset somewhere?


Thank you in advance.

Daniel

[dknight]

Hello Daniel,

Try changing the name & description column char set, ie:

ALTER TABLE `jos_hp_properties` CHANGE `name` `name` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL;
ALTER TABLE `jos_hp_properties` CHANGE `intro_text` `intro_text` TEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL;
ALTER TABLE `jos_hp_properties` CHANGE `full_text` `intro_text` TEXT CHARACTER SET utf8 COLLATE utf8_swedish_ci NULL DEFAULT NULL;

[kjelstrup]

Thank you for the reply!

In which file do I have to check it?

[dknight]

You need to the the SQL queries to your MySQL database. If you have access to phpMyAdmin, you can do it from there under 'SQL' tab.

[-TS-]

Hi,

I have this same problem and this solution did not work.

Problem is that search funtion does not understand ä,ö etc letters.

Does it help for finding solution to this problem to know that in mysql letter ä is ä and ö is ö ?
Search is working so far ok until first ä-letter comes.