mysql table in utf8 but database in latin1?
I have a MySQL 5.0.22 database. It's delivering garbled text (the traditional latin1 vs. utf8 issue). I converted the fields in a particular table to blobs, then used "ALTER TABLE t1 CHANGE c1 c1 TEXT CHARACTER SET utf8" to convert each field to utf8. The problem? The text still appears garbled.
When I issue the status command (/s) I see this:
mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (x86_64) using readline 5.0
Connection id: 441212
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
My concern is that everything is still latin1. Wouldn't that force conversions of the characters in my new utf8 table? Or is it something else? And how would I configure a single table to work with utf8 while everything else remains latin1?