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.
Replying to
Down the road we should collaborate on something (not an excuse but crazy busy now). Cheers!
1
1
Also, I really love the tools you guys are putting out there for people. Google really is catching up and even surpassing Amazon with some of the features and services that you have. Keep it up! Your tools make the work I do far easier at times.
1
1
1
Replying to
1
1
Show replies