As you will gather I am very new to SQLite and indeed to databases in general, so please bear with me.
I am using the Singular SQLiteExplorer 3.04 to examine a Rootsmagic database. When I display a particular table, right click on a particular blob cell in the "Fields" column and select "Copy cell to Clipboard" I get <?xml version="1.0" encoding="UTF-8"?> <Root><Fields><Field><Name>Page</Name><Value>Q4 1945 Newcastle upon Tyne 10b 215</Value></Field></Fields></Root> which I what I expected. However, if I instead select "Copy Result Set To Clipboard" and then pick out the same cell fromn the clipboard contents, I get: fields="77u/PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPFJvb3Q+PEZpZWxkcz48RmllbGQ+PE5hbWU+UGFnZTwvTmFtZT48VmFsdWU+UTQgMTk0NSBOZXdjYXN0bGUgdXBvbiBUeW5lIDEwYiAyMTU8L1ZhbHVlPjwvRmllbGQ+PC9GaWVsZHM+PC9Sb290Pgo=" Can anyone please suggest what encoding is in use here? How on earth can the 208 characters in the second version encode for the 145 characters in the first? Brian -- Brian Pears (Gateshead) _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
