df = pd.read_sql(query, con) Response: UnicodeDecodeError Traceback (most recent call last) C:\ProgramData\Anaconda3\lib\site-packages\ibm_db_dbi.py in __get_description(self) 1035 column_desc.append(ibm_db.field_name(self.stmt_handler, -> 1036 column_index)) 1037 type = ibm_db.field_type(self.stmt_handler, column_index) UnicodeDecodeError: 'ascii' codec can't decode byte 0xd1 in position 1: ordinal not in range(128) During handling of the above exception, another exception occurred: Error Traceback (most recent call last) in ----> 1 df = pd.read_sql(query, con) C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\sql.py in read_sql(sql, con, index_col, coerce_float, params, parse_dates, columns, chunksize) 410 coerce_float=coerce_float, 411 parse_dates=parse_dates, --> 412 chunksize=chunksize, 413 ) 414 C:\ProgramData\Anaconda3\lib\site-packages\pandas\io\sql.py in read_query(self, sql, index_col, coerce_float, params, parse_dates, chunksize) 1632 args = _convert_params(sql, params) 1633 cursor = self.execute(*args) -> 1634 columns = [col_desc[0] for col_desc in cursor.description] 1635 1636 if chunksize is not None: C:\ProgramData\Anaconda3\lib\site-packages\ibm_db_dbi.py in __get_description(self) 1080 except Exception as inst: 1081 self.messages.append(_get_exception(inst)) -> 1082 raise self.messages[len(self.messages) - 1] 1083 1084 return self.__description Error: ibm_db_dbi::Error: UnicodeDecodeError('ascii', b'A\xd1O', 1, 2, 'ordinal not in range(128)')
Activity