EPrints Technical Mailing List Archive
See the EPrints wiki for instructions on how to join this mailing list and related information.
Message: #03390
< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First
[EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- To: eprints-tech@ecs.soton.ac.uk
- Subject: [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- From: Jiadi Yao <jy2e08@ecs.soton.ac.uk>
- Date: Wed, 13 Aug 2014 17:33:49 +0100
Hi Jacob, The default charset is the charset used to create new tables and new fields. (e.g. when you add new fields to eprints). It is best to change the default to utf8 (by using the ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;). But this is not directly related to your problem. You need to make sure the existing tables' encoding are in utf8. To check your table encoding, in mysql command line, type: SHOW FULL COLUMNS FROM tablename; The Collation column tells you the current encoding used for the field. I presume you will find them in "Latin1". If so, you will need to convert the table to utf8 encoding: ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; After you converted tables, you will need to re-save the text as the utf8 texts are already corrupted. Best Jiadi On 13/08/2014 15:30, Jacob Wenzel
wrote:
Thanks for your reply Jiadi, but I think all my tables are already utf8, it is only default_character_set_name that is latin1. -- Jiadi Yao jy2e08@ecs.soton.ac.uk EPrints Services 3081, Building 32 University of Southampton |
- References:
- [EP-tech] Conversion of images, videos into preview/thumbnail versions
- From: Jacob Wenzel <jw@energiakademiet.dk>
- [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- From: Jiadi Yao <jy2e08@ecs.soton.ac.uk>
- [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- From: Jacob Wenzel <jw@energiakademiet.dk>
- [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- From: Jiadi Yao <jy2e08@ecs.soton.ac.uk>
- [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- From: Jacob Wenzel <jw@energiakademiet.dk>
- [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- From: Jiadi Yao <jy2e08@ecs.soton.ac.uk>
- [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- From: Jacob Wenzel <jw@energiakademiet.dk>
- [EP-tech] Conversion of images, videos into preview/thumbnail versions
- Prev by Date: [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- Next by Date: [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- Previous by thread: [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- Next by thread: [EP-tech] Re: Conversion of images, videos into preview/thumbnail versions
- Index(es):