- January 10, 2008
- 3
- 0
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.
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.
Hong Kong