home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 2
Feature Requests
EPG/Scheduler case sensitive
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="morpheus_xx" data-source="post: 1282904" data-attributes="member: 48495"><p>Thanks [USER=87524]@fstruijs[/USER] and [USER=141969]@CyberSimian[/USER] for details.</p><p></p><p>[USER=141969]@CyberSimian[/USER], when you are checking this in MP1, what database is used? Probably MySQL. Can you please check how the "programs" table is defined in regards of default charater set and also used collation? See <a href="https://dev.mysql.com/doc/refman/8.0/en/charset-examples.html" target="_blank">here</a> for details.</p><p></p><p>If MySQL uses case insensitive collation here, this has to be ported over to SQLite as well. This can be done by using the custom functions for sorting as I wrote above. Problem is the way TVE3 in MP2 does create the database: it simply copies over an empty template database if none is present. This means we need to create a new template with custom collation and require users to fully setup the TV part again (maybe doing export/import, but anyway a manual process).</p><p></p><p>With TVE3.5/EFCore/(x64) I do no longer need this, it creates a new database from code. So we have more control over this process.</p></blockquote><p></p>
[QUOTE="morpheus_xx, post: 1282904, member: 48495"] Thanks [USER=87524]@fstruijs[/USER] and [USER=141969]@CyberSimian[/USER] for details. [USER=141969]@CyberSimian[/USER], when you are checking this in MP1, what database is used? Probably MySQL. Can you please check how the "programs" table is defined in regards of default charater set and also used collation? See [URL='https://dev.mysql.com/doc/refman/8.0/en/charset-examples.html']here[/URL] for details. If MySQL uses case insensitive collation here, this has to be ported over to SQLite as well. This can be done by using the custom functions for sorting as I wrote above. Problem is the way TVE3 in MP2 does create the database: it simply copies over an empty template database if none is present. This means we need to create a new template with custom collation and require users to fully setup the TV part again (maybe doing export/import, but anyway a manual process). With TVE3.5/EFCore/(x64) I do no longer need this, it creates a new database from code. So we have more control over this process. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Feature Requests
EPG/Scheduler case sensitive
Contact us
RSS
Top
Bottom