keyword search for 3 digit numbers fails

[jcwiok]

Hi everyone,

When I perform a keyword search for a 3 digit number "490", I get no result even though that value exists in our Identifier field. If I search for 490 with "exact match" checked, I get a large return with any number string containing the sequence 490. If I do an advance search with Identifier is exactly 490, I get the result that I want. With number with more than 3 digits, the keyword search performs as expected. Anyone else experience this problem or have a suggestion for how to fix it? I've already re-indexed.

Our site is here:

http://images.library.amnh.org/digital

 

and we are using omeka 2.4.1

Thanks! Jen Cwiok

Digital Projects Manager

AMNH Library 

[Battistella, Marco]

I remember encountering a similar issue. I figured out the reason, I don;t remember exactly what it was, but something in the way mysql implements full text search excludes any 3 or less characters word.

Which would apply to 490

I believe the regular search will not work.

Marco

--
You received this message because you are subscribed to the Google Groups "Omeka Dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to omeka-dev+...@googlegroups.com.
To post to this group, send email to omek...@googlegroups.com.
Visit this group at https://groups.google.com/group/omeka-dev.
For more options, visit https://groups.google.com/d/optout.

[Lukas Pukas]

Hi,

Marco is right, the default minimal word length for word acceptable by fulltext search is 4. To change it to 3, this could help: https://www.electrictoolbox.com/mysql-full-text-index-word-length/

Luk