Support for accented characters and non-Latin text

Pixaria has full support for Unicode and the UTF-8 text encoding so using accented or non-Latin characters should not be a problem for most users provided the MySQL database server software installed by your hosting company is version 4.0 or above.

In versions of MySQL prior to 4.0, there was no built in support for Unicode which means that accented characters stored within the database may not always be reproduced correctly when retrieved. This issue extends to searching which means that if you have accented characters in keywords in the database you may not be able to find images linked to those keywords.

The only solution to this issue is to upgrade to MySQL 4.0 or above but preferably MySQL 4.0.1 which also includes the ability to run Boolean searches.

Go back to contents

Created: Friday, May 19, 2006
Last edited: Friday, May 19, 2006