IRS and Search Case sensitive

Sambonim · **IRS and Search Case sensitive -** 22-06-2007, 04:16 PM

I'm having a problem with the indexation of the words on the "search" and "IRS".
The search it's case sensitive, if i insert the word Domínio, only shows 3 articles, if I insert domínio I will have 21 articles, on IRS it's the same thing.

Sambonim · 05-07-2007, 08:22 AM

Does any one have a solution for this problem?
Please show me the ligth!

Sheep · 05-07-2007, 08:52 AM

I also saw this problem 1 week ago (A staff in my company was playing with all the functions). I found that it's a CODE problem (the search is case insensitiv on some module) and found how to solve this but as atm i'm working on something else (SERM) i can't provide a global fix (many parts have to be fixed).

I was planning on doing a fix for this as soon as i finish my module.
Maybe at the end of the next week?

**Jamie Edwards** · 05-07-2007, 12:08 PM

Submitted as a bug: http://bugs.kayako.com/index.php?cmd=view&id=152

Sambonim · 17-07-2007, 07:33 AM

When the new version will come out?
This it's a very important for the foreigner clients, with this bug fixed we will reduce the number of tickets.

Thank you.

craigbrass · 17-07-2007, 08:29 AM

A huge bug crunch is on at the moment so it will be when that is finished. Don't think it will be too long.

Mahesh Slaria · 20-07-2007, 07:49 AM

Hi Sambonim,

I am unable to duplicate this issue on my development box. We use standard MySQL FULLTEXT search and it is not case sensitive.

Please create support ticket or email me at mahesh.slaria@kayako.com with Admin CP access to trace the issue.

Regards,

Sambonim · 20-07-2007, 01:29 PM

Hello Mahesh, I have sent the email, the subject is IRS and Search Case sensitive.

Thank you.

***John Haugeland*** · 31-07-2008, 07:41 PM

Case sensitivity of fulltext search is governed by the MySQL table/column collation. This is a server configuration issue, not actually a bug.

This may be repaired by the following commands in the mysql console (update the database name and the table name to match those of your install) :

use supportsuitedb;
alter table foo set collation=yourcharset_ci;

Because this is a fix that requires a fair amount of non-trivial work, we are happy to do this for people; if you need that, please open a support ticket.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Sambonim Offline New Member Posts: 19 Join Date: Sep 2006	IRS and Search Case sensitive - 22-06-2007, 04:16 PM I'm having a problem with the indexation of the words on the "search" and "IRS". The search it's case sensitive, if i insert the word Domínio, only shows 3 articles, if I insert domínio I will have 21 articles, on IRS it's the same thing.

Sambonim Offline New Member Posts: 19 Join Date: Sep 2006	05-07-2007, 08:22 AM Does any one have a solution for this problem? Please show me the ligth!

Sambonim Offline New Member Posts: 19 Join Date: Sep 2006	17-07-2007, 07:33 AM When the new version will come out? This it's a very important for the foreigner clients, with this bug fixed we will reduce the number of tickets. Thank you.

craigbrass Offline Senior Member Posts: 5,394 Join Date: Jun 2005 Location: Cumbria, UK	17-07-2007, 08:29 AM A huge bug crunch is on at the moment so it will be when that is finished. Don't think it will be too long. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

Mahesh Slaria Offline Member Posts: 183 Join Date: Jul 2006	20-07-2007, 07:49 AM Hi Sambonim, I am unable to duplicate this issue on my development box. We use standard MySQL FULLTEXT search and it is not case sensitive. Please create support ticket or email me at mahesh.slaria@kayako.com with Admin CP access to trace the issue. Regards,

Sambonim Offline New Member Posts: 19 Join Date: Sep 2006	20-07-2007, 01:29 PM Hello Mahesh, I have sent the email, the subject is IRS and Search Case sensitive. Thank you.