Ukraine
Hi there
I'm working now on support in MediaPortal (both 0.2 and 0.3 versions) cyrilic DVB texts (EPG, channel names, etc.). I have found problem in my TVServer installation. MySQL database is created with hardcoded charset 'latin1' for all tables, and connection with MySQL also use default charset 'latin1'. This make imposiblt to store any non-latin texts - cyrilic, herbew, greek, etc.
Here is my small patch that adds 'charset' parameter in MySQL connection string and change charsets on database creation to 'utf8'. This will fix problem for newely installed TVServer but not for existing. To fix problem on existing database there sholud be some SQL script to change tables and may be columns charset. I have not enoutgh expirience with MySQL and TVServer project to prepare such sctipt.
I'm working now on support in MediaPortal (both 0.2 and 0.3 versions) cyrilic DVB texts (EPG, channel names, etc.). I have found problem in my TVServer installation. MySQL database is created with hardcoded charset 'latin1' for all tables, and connection with MySQL also use default charset 'latin1'. This make imposiblt to store any non-latin texts - cyrilic, herbew, greek, etc.
Here is my small patch that adds 'charset' parameter in MySQL connection string and change charsets on database creation to 'utf8'. This will fix problem for newely installed TVServer but not for existing. To fix problem on existing database there sholud be some SQL script to change tables and may be columns charset. I have not enoutgh expirience with MySQL and TVServer project to prepare such sctipt.