Unicode XMLTV from TVxb (1 Viewer)

[JaLooNz]

TV-Server Version: MP1 RC1 TVengine
MediaPortal Version: MP1 RC1
MediaPortal Skin: BluTwo Wide
Windows Version: Vista SP1 x86
CPU Type: AMD BE-2350
HDD: Seagate 250GB
Memory: 2GB DDR2
Motherboard: Biostar TA690
Motherboard Chipset: AMD R690
Motherboard Bios:
Video Card: AMD X1250 Onboard
Video Card Driver: Catalyst
Sound Card: Realtek HD
Sound Card AC3:
Sound Card Driver:
1. TV Card: Hauppauge PVR150MCE
1. TV Card Type: Hardware Analog
1. TV Card Driver:
2. TV Card: Hauppauge HVR1100
2. TV Card Type: Software Analog, DVB-T
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
Satelite/CableTV Provider:
HTPC Case: Sliverstone GD01MX /w iMon LCD
Cooling:
Power Supply:
Remote: Microsoft MCE Remote
TV: Samsung 32" LCDTV
TV - HTPC Connection: HDMI

Hi,

I am using XMLTV with unicode program names from TVxb, but the importer appears to have some problems. I am using MySQL 5.0. The imported chinese characters appear as ??. (This problem existed since the feature was added in the SVN build, I can only get it to work properly the first time it is imported... and now totally not at all)

In addition, even with the names working properly, recording (in the SVN builds before the RC1) doesn't work. I have not been able to test it with RC1 since the import doesn't even work right. [Might be because the TS writer doesn't support writing to unicode filenames... and thus only the XML file is correctly written]

I have attached a sample of the TVguide from TVxb.

x86 Vista server+client (TVengine, MP)
x64 Vista client

Thanks.

 

[god_md5]

it work in xp ,but mediaportal not have font set ,only have lang set..

 

[JaLooNz]

god_md5
Did you set the locale to Chinese? Can you record to *.mpg format with unicode filenames?

 

[god_md5]

JaLooNz ,it can record

 

[god_md5]

maybe you set all tvxb output is utf-8 ,not "zh",but some font be can not saw.
but can recode.
and the dvb-epg is not work with utf-8 in this ver

 

[mmesh]

TV-Server Version: 1.0RC1
MediaPortal Version: 1.0RC1
MediaPortal Skin: Foofarow
Windows Version: WindowsXP SP3

I can also confirm that importing tvxb generated TVGuide.xml encoded in utf-8 doesn't import well in MySQL v5.0.51 DB.

I think it worked OK with one of the latest v0.2.3 SVN but I can't remember which one was it.

Characters that bug me are EE accented characters (ŠĐČĆŽžćčđš). If I manually correct these entries in MySQL's tvlibrary DB programms table - they show up correctly in GUI (TV Guide).

 

[Doron]

Great news! Everything works fine with MySQL!

Instead of Hebrew, the EPG only showed "????????". Also, when typing channel name in TvServer configuration, it replaced the names with "???????". Moving to MySQL fixed the problem.

Description of storing UTF-8 data in SQL Server
MySQL :: MySQL 5.0 Reference Manual :: 9.1.8 Unicode Support

JaLooNz, please make sure you indeed use MySQL. Choosing MySQL on installation is not enough. When first running TvServer Configuration, you are prompt for SQL and password. Make sure you select MySQL.

1-0 for Sun vs. Microsoft...