Unicode support (1 Viewer)

[cybernn]

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:
<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.​

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

 

[rtv]

I'll take care of this soon

 

[cybernn]

Thanks!

 

[JaLooNz]

I am also looking towards the fixed builds appearing. Hopefully the database tables can be migrated automatically too.

 

[rtv]

Finally I've finished the DB updates. So with the next public build every MySQL DB should automatically be updated to use UTF8 format. Please report back if there are still problems

 

[JaLooNz]

What about MS SQL server? I was trying to get it working for MS SQL but it doesn't appear to work.

 

[rtv]

What about MS SQL server? I was trying to get it working for MS SQL but it doesn't appear to work.

MSSQL does use the database defaults when creating the tables.

So if you set it's language correct it should almost work since it will internally use UCS-2 all the time.

Please read International Features in Microsoft SQL Server 2005 for more details.
You could change all string fields from varchar to nvarchar as well and live with the performance penalty.

For beginners I'd recommend MySQL for now.

 

[JaLooNz]

Migrated to MySQL and the UTF8 fields works great.

Issues with MySQL on Vista earlier cause me to use MS SQL instead.
MySQL Bugs: #34559: MySQLInstanceConfig: side-by-side configuration is incorrect

The solution is to just run ResHacker and modify the manifest.
MySQL :: MySQL Server 5.0.51a Installation guide for Windows Vista

 

[chrissooo]

MSSQL does use the database defaults when creating the tables.

So if you set it's language correct it should almost work since it will internally use UCS-2 all the time.

Hi rtv,

i use also MSSQL. You say that we must set the correct language in MSSQL. German Channels works very good for me. But i look also polsh channels and here i have problem with some characters in the epg Data. How can i get it to work that i can see all characters correctly? Can i set UTF8 in the MSSQL Database? And when its possible ... can i migrate the old Database with just setting new charset of the tables? Or must i recreate the Tables?

Chris

 

[rtv]

Can i set UTF8 in the MSSQL Database? And when its possible ... can i migrate the old Database with just setting new charset of the tables? Or must i recreate the Tables?
Chris

Please read International Features in Microsoft SQL Server 2005 for more details.
You could change all string fields from varchar to nvarchar as well and live with the performance penalty.

For beginners I'd recommend MySQL for now.

If you're not sure what the content above is about:
1. Export your channels to XML, write down pending schedules, remember settings
2. Install MySQL
3. Update TVE3 - choose MySQL
4. Import data from step 1.