OTLAgk250q1G1I5TPw7j1LuSQ/N7JljB2RtqIfvR4hc9UlNO/GAjTOjFMEhjb5fpnCv/EGdODUnaĨZMORffQqRAhQyFgwC/0GsZdx1Dc87atpcBY50OQ0jtB0O14O5UQaLlLTBCM+Mj44pVdvAKt5i4OĪxQu0TfJWLl0Hy1euYn5SUU3aMExfd3UPKAfUgmZsdLGTfuQCaEkxyalSDf2A9q/d/dC3KtVS0b1īd2FZEZKcRMTy+SuNBOlLZSVsLxUORNOCUHbb4dh2/m+dB1X8gFTjeklVlSShObDDpNjOMQRFTK4 Rh9Haefj4xd1OpHvqo33DTfMUP6ARoNMZ8VyXYopG圓9AENaIHaUXFI2EmpALPVVZQtiKAm6fq8Xĭ7w+U5PzFxblE3ZJIYNTBlOVq4nmU415Bc27TCsj2BTOfqSU5U2Xxu3Ij9u9xNvVvOTLDKaitNwP U9CgvROxObcAf/zWPH8Bd/RsuAkHm7Ncl3Nx4vKu40dhkHhHmlEUKC4lSuLFJRTdZFYrMScHKUuS ND+3nMvzX/mQZwhku1r17Acyc2hui9Z+C3arU9aEnEvYZ+fPuVs88INuknh9LJm0PIMZDmiXcRT7ĬdwLvYfX6BI8KxB2kFu9eDlCyNHAvjSW28oaWPw0VlKVfEx2DbelnfFsLCo5MmLxUjobk8tHeyorĪMKK3BwufteXLyI0d3QlFRxgRc8pHE1aTAsuHe1J6Kc9YvaBVhkibWFkLrhxm7WYQ99SwA0csinRĩtovdJuJY+Ir7Xl3tJmV4MPe2TM7lvOZ9O+NZxLOnh2N5UzMRnM4mJ//rDfFl7A3PJkJGlbAQSFz SiYMqCHsFlhyYzVNSK5Gfq/dSb19Sf5KWlXRMHiiKu2uNNoWqEs1KeaGZ4beoATz293wkbdNA1Ag We1G0Et6fthOA+8es6g5ExwlnFYaHgwFjnDGjUFpsoINbasRBr223+kmgfctStRMAJM5ZKqcMM0sĬQUoc5VpLpVQo3mrEQRxx++l8SOvT9aJZVCizpitNMNGFHU7fhB3H3nN+1Oe88o04TvpGDfczmFb viUlROBxzNui2PUWmnTsmb6AWu4AHfeH/+oE4SX8Q/TzkYQxWkabkDwj+36Gj7z+O/3+4fe0f7R H4sIAAAAAAAAA+1YPXPbRhBVC/6KDV2oCSh8kSAzaSTFjuSRZc9QiV14RnMElsSZhzvq7kCaatOmĬZMmhceJi/g/pKPU5Udlj5Ql2R4P43giJzFeQRCLw93e2327NzAnglv0K4kmYxPM/XwgTipFpolWĪ4Hl1sZHI圜kQeCuYdp+4/oaG2ESBXEUJVEcbtDTMAk2oP3xS69HZSzTABtK8Cnq949b9/w/CrM2 $ base64 -d 64 > sqlite-unescaped-dblquote-problem.tgz ![]() Then do the following from the shell (the '$' represetns shell prompt): Paste the base64 stuff shown below (between the start/end markers) into a file "64", To recreate the tgz file, do the following: I did create a *.tgz file from that directory and used base64 to create an ASCII representation of it. One import creates prolems, the other one - unexpectedly - NOT! The names of the tsv files explain what happens: It just uses importer.sqlite3 for creating tables by importing the two tsv files. ![]() Install Reason : Installed as a dependency for another packageįor testing I created a directory "sqlite-unescaped-dblquote-problem" with the following files: Required By : avidemux-cli colord docker gnupg ipython libaccounts-glib libchamplain libsoup libsoup3 neomutt nss python-apsw python2 python2-apsw qt5-base subversion tracker3 webkit2gtk zathura Independent of how doublequotes are handled in csv mode (or csv mode with \t as separator),ĭescription : A C library that implements an SQL database engine I could disable this warning when replacing the first occurence of " by \". The bahaviour that motivated me to write this message here, Using \t as separator, even though I switched to csv mode.īut maybe I have overlooked something regarding the handling of csv and doublequotes from within the sqlite3 tool. I would expect that doublequotes are not a problem, when I have a problem with importing a tsv file.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |