#142
  • Created on
    2008-04-06 15:15
  • Reported by
    Pernod
  • Status
    Closed
  • Priority
    Normal (3)
  • Assigned to
    Pernod
  • Milestone
    1.24
  • Plan Level
    -
  • Due Date
    -

Attachments

Related Tickets

Add new subtask or bug

Convert the database to UTF-8

The database is currently latin1 which restricts foreign language characters that can be saved. Re-creating the database with UTF-8 support would solve many encoding issues.
When this is done the following areas of code will need updating:
RSS
iTunes
OFDb parser
...
User picture
  on 2011-04-01 18:58 *
By Pernod
Component changed from None to Database
User picture
  on 2011-04-02 19:04 *
By Pernod
Milestone set to 2.00
User picture
  on 2012-05-18 02:05 *
By Pernod
Assigned to set to Pernod
(In revision:1689) Removed old database setup and patches, and added a new setup.sql that creates a new database using the InnoDB engine with UTF-8 encoding.

Refs #142
User picture
  on 2012-05-18 11:34 *
By Pernod
(In revision:1698) Removed database charset and collation checks as these are now correctly specified during database creation.

Refs #142
User picture
  on 2013-01-09 11:56 *
By Pernod
(In swiss:1764) Converted all database tables to utf8 encoding, and fixed some missing indexes on dirname, filename. Refs #142

Re-applied unique indexes on all media tables to eliminate the possibility of duplicate files in the database. Closed #281
User picture
  on 2013-01-12 20:29 *
By Pernod
Milestone changed from 2.00 to 1.24
Status changed from New to Closed