Reply to thread

Message

<blockquote data-quote="cybernn" data-source="post: 245230" data-attributes="member: 47623">Tell please, whether probably to change installer, thus that it would create tables MySQL in the coding utf8, instead of latin1. And that for support cyrillic symbols it is necessary to make following actions at installation:I install TV Server. Then I do by means of mysql-gui-tools backup bases tvlibrary. The given file I open in Notepad, replace all found 'latin1' on 'utf8'. 
In mysql-gui-tools I delete base tvlibrary. Then I restore it from the changed archive.

Then in file C: \Documents and Settings \All Users \Application Data \MediaPortal TV Server \Gentle.config I add in the end connectionstring - 'charset=utf8', that the following would turn out: 
&lt;DefaultProvider name=&quot;MySQL&quot; connectionString=&quot;Server=mserver;Database=TvLibrar y;User ID=root;Password=xxxxx;charset=utf8&quot; /&gt;

After each updating TVServer file Gentle.config needs to be changed. I act as follows - After each updating I copy in folder C: \Documents and Settings \All Users \Application Data \MediaPortal TV Server kept 1 time a file. After that it is necessary rescanning all which channels of the name not in the coding latin1 and if you use xmltv that compulsorily to start updating.The given decision works for me stably 4 months. As a result I have received correct display cyrillic fonts, names of channels, and Russian EPG</blockquote>

[QUOTE="cybernn, post: 245230, member: 47623"] Tell please, whether probably to change installer, thus that it would create tables MySQL in the coding utf8, instead of latin1. And that for support cyrillic symbols it is necessary to make following actions at installation: [INDENT]I install TV Server. Then I do by means of mysql-gui-tools backup bases tvlibrary. The given file I open in Notepad, replace all found 'latin1' on 'utf8'. In mysql-gui-tools I delete base tvlibrary. Then I restore it from the changed archive. Then in file C: \Documents and Settings \All Users \Application Data \MediaPortal TV Server \Gentle.config I add in the end connectionstring - 'charset=utf8', that the following would turn out: <DefaultProvider name="MySQL" connectionString="Server=mserver;Database=TvLibrar y;User ID=root;Password=xxxxx;charset=utf8" /> After each updating TVServer file Gentle.config needs to be changed. I act as follows - After each updating I copy in folder C: \Documents and Settings \All Users \Application Data \MediaPortal TV Server kept 1 time a file. After that it is necessary rescanning all which channels of the name not in the coding latin1 and if you use xmltv that compulsorily to start updating.[/INDENT] The given decision works for me stably 4 months. As a result I have received correct display cyrillic fonts, names of channels, and Russian EPG [/QUOTE]

Verification