Go Back   Mosets Community > Archives > Mosets Hot Property 1.0 > Discussions, Troubleshooting and Problems

 
 
Thread Tools Search this Thread Display Modes
  #1  
Old 02-10-2009, 06:14 AM
kjelstrup kjelstrup is offline
Mosets'd
 
Join Date: Aug 2006
Posts: 7
Default , , doesn't work in components search module - advanced search is working proper

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
  #2  
Old 02-10-2009, 09:59 AM
dknight dknight is offline
Mosets Team - Lead Developer
 
Join Date: Dec 2004
Posts: 27,205
Default

Hello Daniel,

Try changing the name & description column char set, ie:
Code:
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;
__________________
Lee
Lead Developer
Mosets.com - Quality Joomla! Solutions
  #3  
Old 02-16-2009, 02:40 AM
kjelstrup kjelstrup is offline
Mosets'd
 
Join Date: Aug 2006
Posts: 7
Default

Thank you for the reply!

In which file do I have to check it?
  #4  
Old 02-16-2009, 11:26 AM
dknight dknight is offline
Mosets Team - Lead Developer
 
Join Date: Dec 2004
Posts: 27,205
Default

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.
__________________
Lee
Lead Developer
Mosets.com - Quality Joomla! Solutions
  #5  
Old 04-15-2009, 03:07 PM
-TS- -TS- is offline
Mosets'd
 
Join Date: Jan 2007
Posts: 16
Default

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.
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +8. The time now is 03:58 AM.

Copyright © 2005-2010 Mosets Consulting

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.