I would suggest following up with RootMagic and see if they have overloaded one of the builtin collation sequences (NOCASE comes to mind) with something else -- perhaps something that knows how to do Case Insensitive and Accent Insensitive across the entire Unicode spectrum.
Can you issue direct SQL Queries to RootMagic, or does it only use "pre-canned" queries (pre-canned includes anything where you cannot type an SQL statement to execute) such as QBE interfaces. -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > -----Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of moma...@yahoo.com > Sent: Tuesday, 23 May, 2017 11:08 > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] Is this a problem? > > I am new to SQite. I am not new to queries. I am a 28 year QA Tester. I > have been doing queries and macros for the past 25 years. > > I ran the following query over my RootMagic 7 (Version 7.22.3.0 – 24 Jan > 2017)database in SQLite Spy (Version 1.9.11 Win32): > > --integritycheck.sql > PRAGMA integrity_check; > > I expected to get an OK to be returned. > > I actually got the following results: > multiple rows of “row ??? missing from index idsSourceTemplateName” > multiple rows of “row ??? missing from index idxPlaceName” > multiple rows of “row ??? missing from index idxSurnameGiven” > “row ??? missing from idx Surname” > Multiple rows of “row ??? missing from index idxGiven” > > Yet when I do an integrity check in Rootsmagic 7, it comes back OK. > I am kinda confused. RootsMagic says it is ok but SQLite says there are > problems. > > OR, am I doing something wrong in SQLite? > > If I am not doing anything wrong in SQLite, how do I fix this? > If I fix this in SQLite, now I am afraid I won’t get an ok in RootsMagic > on their integrity check. > > > Sent from Mail for Windows 10 > > _______________________________________________ > 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