Sunday, 15 February 2015

python - Entering special characters in database -



python - Entering special characters in database -

i scanning scheme , entering file names sqlite3 database using python.

one of files happens have special character in name , produces error while inserting record. file name.

a¿.mp3

this query

self.cursor.execute("insert tracks values (?)", i)

also due special character, unable encode in utf-8.

is there other encoding can utilize add together info database?

you can seek utf-16 encoding, or adding '' around special character.

python sqlite3 special-characters

No comments:

Post a Comment