[VuFind-Tech] Diacritics woes -- mysql?

[Rayner, J. <ra...@ei...>]

We’re having a problem with diacritics that I think if MySQL database related.

The name looks correct in the Solr document
<str name="title">Chicharito : la historia de Javier Hernández /</str>

But,  Title field in the database is not correct

Chicharito : la historia de Javier HernaÌndez

The default charset for the resource table is utf8
The character_set_database is latin1 and the collation_database is latin1_swedish_ci

Does this make sense that this is a database issue?    Should I be looking at changing the charset of one of these?

Regards

June Rayner
ILS Application Team
(412) 622-1941
ra...@ei...



The information contained in this e-mail, and any attachment, is confidential and is intended solely for the use of the intended recipient. Access, copying or re-use of the e-mail or any attachment, or any information contained therein, by any other person is not authorized. If you are not the intended recipient please return the e-mail to the sender and delete it from your computer. Although we attempt to sweep e-mail and attachments for viruses, we do not guarantee that either are virus-free and accept no liability for any damage sustained as a result of viruses.