Problem loading utf8 Thai Tweets to PostgreSQL

api

#1

Good day. I’m working on with tweets from Thailand with python and postgresql. Line number 50 works but sometimes it just get error and passes to the except of the code. Any idea why is this happening? I created 2 columns in the table with the same input but one in ascii and one in utf8. The help from this community is very much appreciated.



#2

This is more of PostgeSQL issue, as twitter API will always send utf8. You may need to update your table to use utf8: https://www.postgresql.org/docs/9.5/static/multibyte.html


#3

Good day sir. I already check my database encoding format. It is using utf8. still struggling with the problem. thanks for the reply.