So to confirm. In python 3, the str type should be used for name? Thanks.
On Thu, Jan 30, 2020 at 12:58 AM Keith Medcalf <kmedc...@dessus.com> wrote:
>
> sys.argv is a list of unicode text strings. There is no need to
> specifically encode or decode it so long as sys.getdefaultencoding()
> returns 'utf-8'. If your version of Python is so old that it returns
> something else then you need to modify site.py and have it set the default
> encoding to 'utf-8' otherwise you may end up with MBCS or some other
> invalid text encoding in your database text fields.
>
> --
> 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 <sqlite-users-boun...@mailinglists.sqlite.org> On
> >Behalf Of Peng Yu
> >Sent: Wednesday, 29 January, 2020 22:57
> >To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
> >Subject: [sqlite] Is it necessary to encode() for file names in sqlar
> >format?
> >
> >I use the following python3 code to create sqlar file. Is it necessary
> >to sys.argv[2].encode('utf-8') in the line of execute()? In other
> >word, does the native sqlar tools inteprete the name column as an
> >encoded value or a non-encode value? Thanks.
> >
> >import sqlite3
> >conn=sqlite3.connect(sys.argv[1])
> >c=conn.cursor()
> >c.execute('''
> >CREATE TABLE IF NOT EXISTS sqlar(
> >name TEXT PRIMARY KEY
> >, mode INT
> >, mtime INT
> >, sz INT
> >, data BLOB)
> >''')
> >
> >import zlib
> >data = sys.stdin.buffer.read()
> >c.execute('REPLACE INTO sqlar VALUES(?, ?, ?, ?, ?)', [sys.argv[2], 0,
> >0, len(data), zlib.compress(data)])
> >conn.commit()
> >
> >--
> >Regards,
> >Peng
> >_______________________________________________
> >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
>
--
Regards,
Peng
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
