Re: [sqlite] Is it necessary to encode() for file names in sqlar format?

Yes. If it is bytes type then the data stored by the database will be a BLOB, not TEXT ... -- 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 On >Behalf Of Peng Yu >Sent:

Re: [sqlite] Is it necessary to encode() for file names in sqlar format?

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 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

Re: [sqlite] Is it necessary to encode() for file names in sqlar format?

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

[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])