See the Mailing Lists Page for how to subscribe and unsubscribe.
eprints_tech messages
Please note: this page shows emails that have been sent to the eprints_tech mailing list. Some of these may be spam emails we have failed to filter.
[EP-tech] mysql - change tables to unicode
From: "Roman Chyla" <roman.chyla AT gmail.com>
Date: Wed, 7 May 2008 16:45:04 +0200
*** ↵ http://www.eprints.org/tech.php/id/%3Cea0115e90805070745h4e73e172u4388d4ef103e313e%40mail.gmail.com%3E *** EPrints community wiki - http://wiki.eprints.org/ Hello, this thread be useful for others as a reference, there were more questions regarding unicode (utf8) in the past. We have wide characters everywhere, but everything looks fine, imported 2k articles and they are displayed correctly. It did not occur to me until when searching for uppercase 'È' (smallcase è is found) I think the problem is in the database. Whe the installation script created the mysql tables for me and I suppose the mysql engine took the default encoding (when none specified) which was latin1 in my case. And collation swedish. It is a production server, so I am more careful, do you think I can do something of these? 1. change some tables only (set encoding and collation)? Which ones though? 2. or can I simply change the encoding and collation on the tables directly, without any effect on data? 3. possibly dumb, convert to utf8 and import schema and import data as utf8? Thank you for your hints, roman
[index] [prev] [next] [options] [help]