Reply to thread

Message

<blockquote data-quote="d-fader" data-source="post: 310376" data-attributes="member: 25116">el_gato: Don't bother, I've found it, it was a bug, I guess... Don't shoot me, since I checked this in a hurry, since I'm actually at work ATM <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" /> and multi-tasking is not something I greatly do <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" />The old code made an uppercase value of the input value and checked that against what was stored in the database. e.g. You type 'Boston' in GS and GS will create the query: SELECT [...] WHERE Upper(strArtist) = &quot;BOSTON&quot; [...]. Using umlauts worked, but SQLite doesn't give a hit on Upper(strArtist) = 'BÖSTON' when &quot;Böston&quot; is stored in the database. I changed this in a way that the code doesn't capitalize the phrases, but the database will, i.e.: Upper(strArtist) = Upper('Böston'). This seems to work like a charm!Expect a new version with Lyrics search this evening! I hope I can manage it!I'm back to work now (almost done <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />)</blockquote>

[QUOTE="d-fader, post: 310376, member: 25116"] el_gato: Don't bother, I've found it, it was a bug, I guess... Don't shoot me, since I checked this in a hurry, since I'm actually at work ATM :P and multi-tasking is not something I greatly do ;) The old code made an uppercase value of the input value and checked that against what was stored in the database. e.g. You type 'Boston' in GS and GS will create the query: SELECT [...] WHERE Upper(strArtist) = "BOSTON" [...]. Using umlauts worked, but SQLite doesn't give a hit on Upper(strArtist) = 'BÖSTON' when "Böston" is stored in the database. I changed this in a way that the code doesn't capitalize the phrases, but the database will, i.e.: Upper(strArtist) = Upper('Böston'). This seems to work like a charm! Expect a new version with Lyrics search this evening! I hope I can manage it! I'm back to work now (almost done :P) [/QUOTE]

Verification