Re: Problem with strange chars in text filed.

On 06/09/2014 09:02 AM, Bruce wrote:
> I have a table:
> create table truck (name varchar(45),address varchar(150));
>
> doing an insert:
> for i in range (0,10):
> meme = fake.name <http://fake.name>()
> address = fake.address()
> print (meme,address)
> cur.execute("INSERT INTO TRUCK2 VALUES (%s, %s)", ([meme], [address]))
> conn.commit()

Assuming you are using psycopg2 the answer is here:

http://initd.org/psycopg/docs/usage.html#passing-parameters-to-sql-queries

so:

cur.execute("INSERT INTO TRUCK2 VALUES (%s, %s)", (meme, address))
or
cur.execute("INSERT INTO TRUCK2 VALUES (%s, %s)", [meme, address])

>
> Help
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com