home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Development
General Development (no feature request here!)
MySQL character set
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="AlexPlas" data-source="post: 158148" data-attributes="member: 24336"><p>Hi there</p><p></p><p>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.</p><p>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.</p></blockquote><p></p>
[QUOTE="AlexPlas, post: 158148, member: 24336"] 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. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
General Development (no feature request here!)
MySQL character set
Contact us
RSS
Top
Bottom
