Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
No search results provided in mediawiki for non Latin words
Old 01-27-2010, 03:44 PM No search results provided in mediawiki for non Latin words
Average Talker

Posts: 17
Location: Athens Greece
Trades: 0
I have a mediawiki installation which does not provide search results for words with non Latin characters. Live search works fine, autocompleting on the box, but full text only provides results for Latin based queries.

It is php 5.1.12 and MySQL 5.0.87 mbstring enabled. Multilingual search in other scripts work ok on the server (i.e. SMF/Joomla).

The mediawiki dB was copied by a programmer on an Amazon instance and the search works in that case (the Amazon instance is MySQL: 5.1.37-1ubuntu5 / php 5.1.10).

Any mediawiki experts out there?
__________________
Spiros Doikas

Please login or register to view this content. Registration is FREE

Last edited by translatum.gr; 01-27-2010 at 04:55 PM..
translatum.gr is offline
Reply With Quote
View Public Profile Visit translatum.gr's homepage!
 
 
Register now for full access!
Old 01-27-2010, 03:52 PM Re: No search results provided in mediawiki for non Latin words
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,528
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
Change the database character set to UTF
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 01-27-2010, 04:46 PM Re: No search results provided in mediawiki for non Latin words
Average Talker

Posts: 17
Location: Athens Greece
Trades: 0
Thanks! It was a bug caused by Extension:SimpleSecurity

There is a global variable called $wgDBtype that for some reason, the SimpleSecurity extension saw fit to muck with.

Part of the search subsystem depended on this variable being set to "mysql", as it should be. In languages/Language.php, there is the following code:
if ( $wgDBtype != 'mysql' ) {
return $string;
}

$wgDBtype wasn't set to "mysql", so the search string was returned in its raw state. But it needed to be converted! As noted here:

# MySQL fulltext index doesn't grok utf-8, so we
# need to fold cases and convert to hex
__________________
Spiros Doikas

Please login or register to view this content. Registration is FREE
translatum.gr is offline
Reply With Quote
View Public Profile Visit translatum.gr's homepage!
 
Reply     « Reply to No search results provided in mediawiki for non Latin words
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.28419 seconds with 12 queries