Re: [sqlite] Re: Python-Sqlite Unicode characters

2007-03-30 Thread Kostas5904
This is how I solved the problem (in case somebody else face it in the future): ... item=dialog.GetValue() cols="id,attr,type" table="names1" v="(%s, '%s', %s)" % ("null",item,3) #the whole job is done by the ' %s' a="insert into

Re: [sqlite] Re: Python-Sqlite Unicode characters

2007-03-29 Thread Dennis Cote
Igor Tandetnik wrote: Kostas5904 wrote: But... When I ask a value from the user and I try to store it into the same table, I run the following code item=dialog.GetValue() table="names1" cols="id,descr,type" values=("null",item,3) a="insert into %s (