Chinese EPG Development just 2 points to make it work

frankong38 · 2008-06-18, 18:23

I had been working to make Chinese or indeed any double-bytes character to display on EPG. Indeed, there is just a few steps to make it work. However, I am new here and need some pointer or help to make the code change. Here's the idea:-

1. A couple of fields need to change the data type from varchar to nvarchar. They are:
- "Title" and "Description" fields in the table "Program", "Recording"
- "ProgramName" field in the table "Schedule"
- "FileName" field in table "Recording"

2. Whenever update is made to these fields, use
- update <table> set <field> = N'<value>'
where <table> is the table name, <field> is the field name, <value> is the value containing chinese character or so

And of course, the regional setting should be point to the right Lanuage, e.g. Chinese (Taiwan), to display traditional chinese.

I had tried manually inserting Chinese character to table and it show properly on MP Client. So appreciate to give me a pointer to start with.

god_md5 · 2008-06-18, 23:24

is the Taiwan dvb-epg same to hongkong?
if you want hongkong ts file ,i can seed to you

hiroshi yui 90 23 7E 8C 52 87 (?? Me TV ???????????????)
inisde a.2
http://www.dvb.org/technology/standa...468.V1.8.1.pdf
chinese info
´M¬P±Ú¶é¦a - ¤¤¤å¶Ã½X

frankong38 · 2008-06-19, 06:00

I am in HK. I would like to help changing the program code so that the update of Chinese character in EPG related area will not turn into "???". Any information regarding this will be appreciated! Thx!

god_md5 · 2008-06-19, 14:34

you can see here
please help for add utf-8 to dvb-epg

linuxbaba · 2008-07-27, 23:02

Quote:

Originally Posted by frankong38

I had been working to make Chinese or indeed any double-bytes character to display on EPG. Indeed, there is just a few steps to make it work. However, I am new here and need some pointer or help to make the code change. Here's the idea:-

1. A couple of fields need to change the data type from varchar to nvarchar. They are:
- "Title" and "Description" fields in the table "Program", "Recording"
- "ProgramName" field in the table "Schedule"
- "FileName" field in table "Recording"

2. Whenever update is made to these fields, use
- update <table> set <field> = N'<value>'
where <table> is the table name, <field> is the field name, <value> is the value containing chinese character or so

And of course, the regional setting should be point to the right Lanuage, e.g. Chinese (Taiwan), to display traditional chinese.

I had tried manually inserting Chinese character to table and it show properly on MP Client. So appreciate to give me a pointer to start with.

Hi are you came from Hong Kong ... if yes.... you can come here
MediaPortal for Hong Kong - ???? - ???? - Powered by Discuz!

frankong38 · 2008-07-28, 04:18

Thanks a lot, 香港醒目仔!

linuxbaba · 2008-08-09, 23:18

I build it by my own, you can try here

MediaPortal TV-Server 1.0.0.0 RC2 RC2 19801 HK ?? - MediaPortal for Hong Kong - ???? - ???? - Powered by Discuz!

2008-06-18, 18:23	#1 (permalink)
frankong38 Portal User Join Date: Jan 2008 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts	Chinese EPG Development just 2 points to make it work I had been working to make Chinese or indeed any double-bytes character to display on EPG. Indeed, there is just a few steps to make it work. However, I am new here and need some pointer or help to make the code change. Here's the idea:- 1. A couple of fields need to change the data type from varchar to nvarchar. They are: - "Title" and "Description" fields in the table "Program", "Recording" - "ProgramName" field in the table "Schedule" - "FileName" field in table "Recording" 2. Whenever update is made to these fields, use - update <table> set <field> = N'<value>' where <table> is the table name, <field> is the field name, <value> is the value containing chinese character or so And of course, the regional setting should be point to the right Lanuage, e.g. Chinese (Taiwan), to display traditional chinese. I had tried manually inserting Chinese character to table and it show properly on MP Client. So appreciate to give me a pointer to start with.

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
Rev18215 dvb epg chinese .	god_md5	pre 1.0 RC1	0	2008-03-26 00:30
Chinese character support development	Isaac Lin	General Development (no feature request here!)	11	2007-10-26 23:59
how to make EPG work for norway ?	Al_Capone	WebEPG	3	2006-10-19 13:45
EPG grabber development	James	WebEPG	7	2006-04-12 12:55
How to make powerscheduler work with auto-updating EPG?	Rybber	General Support	4	2005-11-14 20:55

2008-06-18, 23:24	#2 (permalink)
god_md5 Portal Member Join Date: Mar 2008 Posts: 34 Thanks: 2 Thanked 2 Times in 2 Posts Country:	is the Taiwan dvb-epg same to hongkong? if you want hongkong ts file ,i can seed to you hiroshi yui 90 23 7E 8C 52 87 (?? Me TV ???????????????) inisde a.2 http://www.dvb.org/technology/standa...468.V1.8.1.pdf chinese info ´M¬P±Ú¶é¦a - ¤¤¤å¶Ã½X

2008-06-19, 06:00	#3 (permalink)
frankong38 Portal User Join Date: Jan 2008 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts	I am in HK. I would like to help changing the program code so that the update of Chinese character in EPG related area will not turn into "???". Any information regarding this will be appreciated! Thx!

2008-06-19, 14:34	#4 (permalink)
god_md5 Portal Member Join Date: Mar 2008 Posts: 34 Thanks: 2 Thanked 2 Times in 2 Posts Country:	you can see here please help for add utf-8 to dvb-epg

2008-07-28, 04:18	#6 (permalink)
frankong38 Portal User Join Date: Jan 2008 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts	Thanks a lot, 香港醒目仔!

2008-08-09, 23:18	#7 (permalink)
linuxbaba Portal User Join Date: Jul 2008 Location: Hong Kong Posts: 3 Thanks: 0 Thanked 0 Times in 0 Posts Country:	I build it by my own, you can try here MediaPortal TV-Server 1.0.0.0 RC2 RC2 19801 HK ?? - MediaPortal for Hong Kong - ???? - ???? - Powered by Discuz!