I've got gb2312 data stored in
the "TITLE" column (the rest of the table is utf-8)
I connect using utf-8, do:
c.execute('SELECT title from table')
and get:
'utf8' codec can't decode byte 0xa8 in position 3: unexpected code byte
I can do this from the mysql prompt though.
I've tried using various CAST, CONVERT,
different connection encodings for unicode=
etc., but can't get the column data to show
up. I got the data in via MySQLdb, so it'd
be nice to get it out.
Any ideas?
THanks,
Bill
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've got gb2312 data stored in
the "TITLE" column (the rest of the table is utf-8)
I connect using utf-8, do:
c.execute('SELECT title from table')
and get:
'utf8' codec can't decode byte 0xa8 in position 3: unexpected code byte
I can do this from the mysql prompt though.
I've tried using various CAST, CONVERT,
different connection encodings for unicode=
etc., but can't get the column data to show
up. I got the data in via MySQLdb, so it'd
be nice to get it out.
Any ideas?
THanks,
Bill
Still doesn't work, but I can retrieve the
data with a MySQL command prompt itself.
Latin1 of course works :()
Anyone have any suggestions?
Bill