[Solution] When inserting "0001" into the column of string in sqlite3, it is entered as "1".

import sqlite3
DATABASE = "unko"

def sql4execute(sql,params=[]):
  db = sqlite3.connect(DATABASE)
  db.text_factory = str  
  cur = db.execute(sql,params)
  db.commit()
  db.close()

sql = "insert into unko (a)  values ('0001')"
sql4execute(sql)
#to unko a'1'Enter
#Since the number of digits of a is not fixed, zero padding is not possible.

Recommended Posts