by Barry4679 » Wed Sep 22, 2021 1:18 am
I don't know enough about Powershell, or whatever you are using, to understand why it is failing for you.
I do know that the dll gets around the IUNICODE error as illustrated by:
- download the open source DB Browser for SQLite
- Run this query ... Select Album from Songs where album = 'xxx';
- you get the missing collation issue
- use menu option Tools|LoadExtension to load Petrs dll
- rerun the query ... runs OK now
I remain surprised that you are getting the collation error from a query which selects a text column, but does nothing which should require collation.
eq. close and reopen the open source browser ... the following query runs OK without the collation
select album from songs LIMIT 1
Does
this offer you any assistance?
You could try sending a PM to PetrCBR. He is the MM Dev who works in this area, although he should have noticed this thread already.
See his post below, where he suggested that another approach is to use their SQL dll, instead of the vanilla SQL library, because theirs already already has some of their customisation baked into it, although I am not sure whether that includes IUNICODE.
viewtopic.php?p=480908#p480908
I don't know enough about Powershell, or whatever you are using, to understand why it is failing for you.
I do know that the dll gets around the IUNICODE error as illustrated by:
[list=]download the open source DB Browser for SQLite[/list]
[list]open the MM5 database[/list]
[list]Run this query ... Select Album from Songs where album = 'xxx';[/list]
[list]you get the missing collation issue[/list]
[list]use menu option Tools|LoadExtension to load Petrs dll[/list]
[list]rerun the query ... runs OK now[/list]
I remain surprised that you are getting the collation error from a query which selects a text column, but does nothing which should require collation.
eq. close and reopen the open source browser ... the following query runs OK without the collation
select album from songs LIMIT 1
Does [url=https://www.sqlite.org/loadext.html]this offer[/url] you any assistance?
You could try sending a PM to PetrCBR. He is the MM Dev who works in this area, although he should have noticed this thread already.
See his post below, where he suggested that another approach is to use their SQL dll, instead of the vanilla SQL library, because theirs already already has some of their customisation baked into it, although I am not sure whether that includes IUNICODE.
https://www.mediamonkey.com/forum/viewtopic.php?p=480908#p480908