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!
1
3
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
Replying to
Down the road we should collaborate on something (not an excuse but crazy busy now). Cheers!
1
1