안녕하세요. 파이썬 배우고 있는 사람입니다.
올려주신 깃허브에 있는 DBUpadaterEx.py를 복붙하면
Traceback (most recent call last):
File "c:/Users/황상훈/Downloads/source (1)/StockAnalysisInPython-master/04_Web_Scraping/DBUpdaterEx.py", line 169, in
dbu.execute_daily()
File "c:/Users//Downloads/source (1)/StockAnalysisInPython-master/04_Web_Scraping/DBUpdaterEx.py", line 136, in execute_daily
self.update_comp_info()
File "c:/Users//Downloads/source (1)/StockAnalysisInPython-master/04_Web_Scraping/DBUpdaterEx.py", line 73, in update_comp_info
curs.execute(sql)
File "C:\python38-64\lib\site-packages\pymysql\cursors.py", line 148, in execute
result = self._query(query)
File "C:\python38-64\lib\site-packages\pymysql\cursors.py", line 310, in _query
conn.query(q)
File "C:\python38-64\lib\site-packages\pymysql\connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "C:\python38-64\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
result.read()
File "C:\python38-64\lib\site-packages\pymysql\connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "C:\python38-64\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
packet.raise_for_error()
File "C:\python38-64\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "C:\python38-64\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.DataError: (1366, "Incorrect string value: '\xEB\x8F\x99\xEC\x9D\xBC' for column investar.company_info.company at row 1")
안녕하세요. 파이썬 배우고 있는 사람입니다. 올려주신 깃허브에 있는 DBUpadaterEx.py를 복붙하면
Traceback (most recent call last): File "c:/Users/황상훈/Downloads/source (1)/StockAnalysisInPython-master/04_Web_Scraping/DBUpdaterEx.py", line 169, in
dbu.execute_daily()
File "c:/Users//Downloads/source (1)/StockAnalysisInPython-master/04_Web_Scraping/DBUpdaterEx.py", line 136, in execute_daily
self.update_comp_info()
File "c:/Users//Downloads/source (1)/StockAnalysisInPython-master/04_Web_Scraping/DBUpdaterEx.py", line 73, in update_comp_info
curs.execute(sql)
File "C:\python38-64\lib\site-packages\pymysql\cursors.py", line 148, in execute
result = self._query(query)
File "C:\python38-64\lib\site-packages\pymysql\cursors.py", line 310, in _query
conn.query(q)
File "C:\python38-64\lib\site-packages\pymysql\connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "C:\python38-64\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
result.read() File "C:\python38-64\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "C:\python38-64\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "C:\python38-64\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "C:\python38-64\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.DataError: (1366, "Incorrect string value: '\xEB\x8F\x99\xEC\x9D\xBC' for column
investar
.company_info
.company
at row 1")이런 오류가 뜨는데 어떻게 해결할 수 있을까요?