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="CyberSimian" data-source="post: 1282910" data-attributes="member: 141969"><p>Firstly, I know nothing about SQL <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite9" alt=":eek:" title="Eek! :eek:" loading="lazy" data-shortname=":eek:" />. However, I have previously downloaded the MP source code and unzipped it. Looking at that, I have this folder:</p><p></p><p>D:\mpsrc\1_25f\MediaPortal-1-master\TvEngine3\TVLibrary\SetupTv</p><p></p><p>This folder contains various SQL files, one of which is "create_mysql_database.sql". Looking in that, I find a definition for the "Program" table, namely this one:</p><p></p><p>[code]--</p><p>-- Definition of table "Program"</p><p>--</p><p>CREATE TABLE "Program" (</p><p> "idProgram" int(11) NOT NULL auto_increment,</p><p> "idChannel" int(11) NOT NULL,</p><p> "startTime" datetime NOT NULL,</p><p> "endTime" datetime NOT NULL,</p><p> "title" varchar(2000) NOT NULL,</p><p> "description" text NOT NULL,</p><p> "seriesNum" varchar(200) NOT NULL,</p><p> "episodeNum" varchar(200) NOT NULL,</p><p> "genre" varchar(200) NOT NULL,</p><p> "originalAirDate" datetime NOT NULL,</p><p> "classification" varchar(200) NOT NULL,</p><p> "starRating" int(11) NOT NULL,</p><p> "notify" bit(1) NOT NULL,</p><p> "parentalRating" int(11) NOT NULL,</p><p> PRIMARY KEY ("idProgram"),</p><p> UNIQUE KEY "idProgramBeginEnd" ("idChannel","startTime","endTime")</p><p>) ENGINE=INNODB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;</p><p>#[/code]</p><p></p><p></p><p>So CHARSET is specified , but COLLATE is not. I searched the entire file to see if COLLATE was specified anywhere (I searched for the string "collat"). There are several occurrences, but they look to me as though they are commented out, as they occur within <strong>/* */</strong> pairs (are those comment delimiters in SQL?).</p><p></p><p>-- from CyberSimian in the UK</p></blockquote><p></p>
[QUOTE="CyberSimian, post: 1282910, member: 141969"] Firstly, I know nothing about SQL :eek:. However, I have previously downloaded the MP source code and unzipped it. Looking at that, I have this folder: D:\mpsrc\1_25f\MediaPortal-1-master\TvEngine3\TVLibrary\SetupTv This folder contains various SQL files, one of which is "create_mysql_database.sql". Looking in that, I find a definition for the "Program" table, namely this one: [code]-- -- Definition of table "Program" -- CREATE TABLE "Program" ( "idProgram" int(11) NOT NULL auto_increment, "idChannel" int(11) NOT NULL, "startTime" datetime NOT NULL, "endTime" datetime NOT NULL, "title" varchar(2000) NOT NULL, "description" text NOT NULL, "seriesNum" varchar(200) NOT NULL, "episodeNum" varchar(200) NOT NULL, "genre" varchar(200) NOT NULL, "originalAirDate" datetime NOT NULL, "classification" varchar(200) NOT NULL, "starRating" int(11) NOT NULL, "notify" bit(1) NOT NULL, "parentalRating" int(11) NOT NULL, PRIMARY KEY ("idProgram"), UNIQUE KEY "idProgramBeginEnd" ("idChannel","startTime","endTime") ) ENGINE=INNODB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; #[/code] So CHARSET is specified , but COLLATE is not. I searched the entire file to see if COLLATE was specified anywhere (I searched for the string "collat"). There are several occurrences, but they look to me as though they are commented out, as they occur within [b]/* */[/b] pairs (are those comment delimiters in SQL?). -- from CyberSimian in the UK [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Feature Requests
EPG/Scheduler case sensitive
Contact us
RSS
Top
Bottom