How convert None to NULL with Python 2.7 and pyodbc

Question

I am passing the output from a sql query to again insert the data to ms sql db. If my data is null python / pyodbc is returning None instead of NULL. What is the best way to convert None to NULL when I am calling another query using the same data. Or a basic string transformation is the only way out ? Thanks Shakti

score 11 · Accepted Answer · edited May 23 '17 at 12:01

11

If you use a parameterized query to perform the insert then you won't have to worry about converting None to NULL (among other benefits). See my recent answer to a related question for details.

edited May 23 '17 at 12:01

Community

1
1

answered Apr 03 '15 at 13:45

Gord Thompson

116,920
32
215
418

score -1 · Answer 2 · answered Apr 03 '15 at 12:07

-1

You could overwrite query function in way that None will be replace with "NULL"

answered Apr 03 '15 at 12:07

Bartłomiej Bartnicki

1,067
2
14
30

How convert None to NULL with Python 2.7 and pyodbc

2 Answers2