Unicode support for Greek charset in WebEPG using MS SQL (1 Viewer)

[lafaki]

Hi,

I have an issue with displaying Greek chars with the WebEPG!

How do you change the charset coding of the MS SQL database without re-installing it?
Is it a configuration or a drop+create all tables from scratch?

FYI, I have configured the default setting to Greek in Language & Regional settings (pre-MediaPortal installation and SQL) as well as the default charset for non-Unicode programs (post-MediaPortal installation and SQL).

Could you please provide the necessary commands and steps?

In case the only solution is to reinstall the db, how this can be done i.e. uninstall and reinstall only the MS SQL database?

Thanx!

 

[arion_p]

Hi Lafaki,

>> I have an issue with displaying Greek chars with the WebEPG!

What exactly is your problem?


>> FYI, I have configured the default setting to Greek in Language & Regional settings (pre-MediaPortal installation and SQL) as well as the default charset for non-Unicode programs (post-MediaPortal installation and SQL).

Language & Regional settings in control panel have nothing to do with language settings in SQL Server. SQL Server has its own language settings (called collations). The default collation is chosen during the installation of SQL Server. If you let MediaPortal installer to install SQL Server, the collation should be correct. Actually I cannot think of a reason the db collation would affect displaying Greek chars.


Arion

 

[lafaki]

Hi,

the greek characters of the EPG are not properly displayed in the MediaPortal client. E.g.

Instead of "Καλημερα Κοσμος του Media", the text "!!??#!??? ??##? ??! Media" is displayed.

In the WebEPG logs I can see that the WebEPG.exe retrieves correctly the greek program text.
It seems to be the way that the MS SQL database stores the text.

I have installed the MS SQL database through the MediaPortal installer.

I am using version 1.0.1

P.S. Is there any way to change the collation and run again the WebEPG.exe and have greek properly displayed?

 

[arion_p]

Your SQL Server collation should be set to Greek_CI_AS.

To check the server collation open SQL Server Management Studio Express (SSMSE) and connect to you local SQL Server. In "Object Explorer" right click your server and select "Properties". In page "General" look at the value of "Server Collation", it should be Greek_CI_AS.

Also expand the "Databases" node, right click the tvserver database (MpTvDb) and select "Properties". In page "General" look at the value of "Collation", it should be Greek_CI_AS. If this is correct, you don't need to change SQL server collation and your problem is elsewhere.

If you do want to change the server collation you can use the following command, but it will delete all SQL Server databases, so you will have to run SetupTV to recreate it and reconfigure TVServer (I am assuming you do not have any other databases):

start /wait setup.exe /qb INSTANCENAME=SQLEXPRESS REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=[I]<your new sa password>[/I] SQLCOLLATION=Greek_CI_AS

The command should be run in a command prompt after changing to the directory "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap". Replace <your new sa password> with your new SA password.


Arion