psycopg2.DataError: unsupported Unicode escape sequence
LINE 1: ...rified":true}}'),(997288960132083715, 15266071...
^
DETAIL: \u0000 cannot be converted to text.
What kind of jerk sticks null bytes in their tweets?
Conversation
Replying to
I had to put in some extra logic to remove them. PostgreSQL doesn't allow null bytes at all, so it throws an error when it encounters one. I will say that if you plan for a dozen ways that something can fail, it will find a thirteenth!
Replying to
Thank you! Eventually I would like to get all kinds of scientific data aggregated so that people can easily find data, run various filters, etc. It's a long road but I get a little closer each day and with each line of code.
2
1
Show replies