MySQL character set

AlexPlas · 2007-06-22, 08:32

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.

cpp2005 · 2007-07-22, 16:45

The same problem exists with mssql server as well.
To fix it, varchar data type need to be changed to nvarchar.
I tried it for Channel table and it is working.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL	KoktGrus	Get Support	2	2007-04-28 18:32
MySQL ?	chenks	General Talk	4	2007-02-18 18:12
MySQL Useable?	Comm	Get Support	2	2007-01-29 09:05
Wrong Character Set for everything but the titles ...	louwke	Installation, configuration support	0	2006-11-06 23:30
MPWebControl with mySQL	klestor	Plugins	2	2006-04-09 19:42

2007-07-22, 16:45	#2 (permalink)
cpp2005 Portal Member Join Date: Nov 2006 Posts: 53 Thanks: 0 Thanked 6 Times in 3 Posts	The same problem exists with mssql server as well. To fix it, varchar data type need to be changed to nvarchar. I tried it for Channel table and it is working.