Loading...
 
Multilingual/i18n

Multilingual/i18n


ready to air my TW site , but ... ... ... PROBLEM with search and create wiki page in Greek

posts: 28

I think that there is no use at all if I say what a great job you all do , delivering to the web community a tool like Tiki-Wiki . I met her (I like to think of TikiWiki like a fairy) last year and I realized that my idea of a collaborative wiki site for practical and useful knowledge can come to reality .

Unfortunately , my site (www.allcanhelp.gr on air just for testing by some friends) has to speak Greek and if I won’t solve the following problems , a whole year of trying will be lost . In written Greek we use accent marks when we write in lower case , but not when we write in capitals . It is obvious that a lower case letter with accent mark has different utf-8 code than the standard lower case letter and the uppercase letter .

I believe that there is a correlation table somewhere which tells to TW that , for example , letter “S” is the same with letter “s” . So if someone searches for the word “service” , can take results for “service” + “Service” + “SERVICE” .

If I could find that correlation table I will try to extend it so it can give results in Greek , not only for upper-lower case but for accented-not accented letters (that’s what google does) .

The same happens when someone is trying to create a wiki page that already exists . If the wiki page title in the database is written in lower case and someone try to create a wiki page with the same title written in uppercase , there will be two wiki pages . This is not happening in English . TW will not create a wiki page titled “service” if a page titled “Service” or “SERVICE” already exists . Instead TW opens the wiki page for editing .

Please , help me to help spreading TW to the Greek web community . I believe that if TW become more Greek-friendly in search and create modules , she can have great success in Greece .

posts: 1092

You are not the only one - the French community that is important in tw has the same problem
1/ which search?
- mysql search:
- tiki search
2/ which database
- mysql is case insentive
- postgres - for which tw will be ready pretty soon is case sentive.
3/ Do you have multibyte support installed on your server.
4/ do you have the locale settings correctly set on your server.

3 and 4 are mandatory

a/ page case insentive
- there is an option in the code to search case sensitive or (I think it will be easy to put the opotion in the interface)(see lib/tikilib/php -> get_page_info
b/ tikisearch + multibyte + locale -> the search should be correct
I do not think that mysql will work properly - missing some mb_convert in the library...

Good luck with the tuning
sylvieg


posts: 28

thanx for your immediate answer and tips sylvie ,

if you can , i need to clear some of your advices :
- i have tw 2.3 and Activated MySQL 'Full-Text' feature in search settings . How can i switch to tiki search and is it possible to solve the problem with the accented/not accented lower case letters ?
- i have mysqli database and so far tried utf8_unicode_ci and greek_general_ci . Is something else i can do ?
- multibyte support in my server ???
- i have uniform server and there is no special local setting except the char set for each database . do i miss smth ???
- pls , just be more detailed for a + b steps

thanx again