I’ve had a problem with searching and display of Greek characters

[Justin Harper]

The problem is that when a search of the database is conducted it does not display the Greek characters correctly. Figure 1 is a  screen dump clearly showing the Greek text in both the display window and the index on the left. However, if I do a search using Greek script to find Greek script, it doesn’t recognise it. If I search using a translated word transcribed to English then it displays as per figure 2. If I click the “hieroglyphic” hyperlink it takes me to the legible record as per Figure 1. So the problem appears to be with the display generated on search. I can work around this on a day-to-day basis but the real problem is that this occurs in the reports generated on queries or holdings for export. 

We have also confirmed the collation of the MYSQL db to be the correct setttings (Figure 3)

Could someone please assist me with the query, I would appreciate it.

Thanks

Justin

[Dan Gillean]

Hi Justin,

In AtoM 2, we have moved to Elasticsearch, which offers search as a service - as such, ES makes sure that all language settings are properly configured by default to use UTF-8 encoding. In ICA-AtoM, which you appear to be using, we were still using Apache Zend Lucene, which relies more directly on PHP configurations. Here is a page that will help you to check the settings in your search index, and ensure that they are defaulting to UTF-8 encoding: http://framework.zend.com/manual/1.12/en/zend.search.lucene.best-practice.html#zend.search.lucene.best-practice.encoding

I would also make sure that any other PHP configuration files, and PHP extensions set up during the installation process are checked to ensure that their default encoding is set for UTF-8.

If that doesn't work, my only other thought would be to try switching the language of the interface to Greek, and performing your search there. Have you added Greek as a language in the language menu? If so, I might suggest switching the language of the application interface to Greek, and then trying your search. Note that adding a new language generally requires you to rebuild the search index.

Hope that helps,

Dan Gillean, MAS, MLIS
AtoM Product Manager / Systems Analyst,
Artefactual Systems, Inc.
604-527-2056

@accesstomemory

--
You received this message because you are subscribed to the Google Groups "ICA-AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To post to this group, send email to ica-ato...@googlegroups.com.
Visit this group at http://groups.google.com/group/ica-atom-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/14cb5c8a-48b6-40ce-a666-3c25b5fc3b4f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.