PyMySQL 獲取資料 'utf-8' codec can't decode byte 0xed in position 2: 錯誤

轉載:  https://my.oschina.net/pallormoon/blog/629807

解決：

PyMySQL 包目錄下的connections.py檔案1232行左右

     def _read_row_from_packet(self, packet):          row = []           for  encoding, converter  in  self.converters:               data  = packet.read_length_coded_string()               if   data   is  not None:                   if  encoding  is  not None:                       data  =  data .decode(encoding)                  

                if  DEBUG: print( "DEBUG: DATA = " ,  data )                   if  converter  is  not None:                       data  = converter( data )              row.append( data )           return  tuple(row)

data = data.decode(encoding)

改為

data = data.decode(encoding,'ignore')