You get the message about missing collating sequences because the database is using collating sequences that you don't have (ie, are missing) in your version of SQLite3.
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Luuk >Sent: Friday, 14 December, 2018 03:18 >To: SQLite mailing list >Subject: Re: [sqlite] Updating Folder_Path in Windows 10 Photos App > > >On 14-12-2018 11:15, Luuk wrote: >> >> On 13-12-2018 18:26, Simon Slavin wrote: >>> On 13 Dec 2018, at 2:57pm, Carlo capaldo ><carlocapa...@hotmail.com> >>> wrote: >>> >>>> UPDATE folder >>>> >>>> SET Folder_Path = 'E:\Photos' >>>> >>>> would change the directory references in all existing 16 rows >>>> currently containing Folder_Path references to the wrong >locations >>>> to the correct location ‘E:\Photos’ however this also generates a >>>> “UNIQUE constraint failed” error. >>> You are correct about what the command does. However, the schema >of >>> the database (its structure, including how all its tables, indexes >>> and views are defined) includes the following: >>> >>> CREATE UNIQUE INDEX Folder_Path ON Folder(Folder_Path); >>> >>> This means that no two rows in the Folder TABLE may have the same >>> values for Folder_Path . I'm sure that makes sense to the person >who >>> defined the schema, so let's look at the current values: >>> >>> sqlite> .mode column >>> sqlite> .width 60 20 >>> sqlite> SELECT Folder_Path,Folder_DisplayName FROM Folder; >> >> >> Just because i was interested in the structure of tis SQLite db, i >was >> looking at the version on my computer. >> >> sqlite> select Folder_Path, Folder_DisplayName from Folder; >> Folder_Path Folder_DisplayName >> ----------------------- ------------------ >> C:\Users\Luuk2\Pictures Pictures >> C:\Users\Luuk2\Pictures Camera Roll >> C:\Users\Luuk2\OneDrive Afbeeldingen >> C:\Users\Luuk2\Pictures Saved Pictures >> C:\Users\Luuk2\OneDrive Schermopnamen >> C:\Users\Luuk2\Pictures Screenshots >> >> OK so far, no problems, but why do i get 'no collation sequence' >with >> this statement: >> >> sqlite> select Folder_Path from Folder; >> Error: no such collation sequence: NoCaseUnicode >> sqlite> >> >> >> >> For completenes the CREATE TABLE for this table (without indexes an >> triggers): >> >> CREATE TABLE Folder( >> Folder_Id INTEGER PRIMARY KEY, >> Folder_ParentFolderId INTEGER REFERENCES Folder ON DELETE >CASCADE, >> Folder_LibraryRelationship INTEGER, >> Folder_Source INTEGER, >> Folder_SourceId INTEGER REFERENCES Source ON DELETE CASCADE, >> Folder_Path TEXT COLLATE NoCaseUnicode, >> Folder_DisplayName TEXT COLLATE NoCaseLinguistic, >> Folder_DateCreated INTEGER, >> Folder_DateModified INTEGER, >> Folder_KnownFolderType INTEGER, >> Folder_SyncWith INTEGER, >> Folder_StorageProviderFileId TEXT, >> Folder_InOneDrivePicturesScope INTEGER, >> Folder_ItemCount INTEGER); >> >> >> >sqlite> .version >SQLite 3.21.0 2017-10-24 18:55:49 >1a584e499906b5c87ec7d43d4abce641fdf017c42125b083109bc77c4de48827 >sqlite> >> >> >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
