I extracted metadata from my image files and stored them in a mysql
table using the default .yml configuration. The meta data includes a
lot of "Copyright (c) Kip 2007 blah blah blah" (only with the real
When I display the information from my app in a browser I got the
"square" replacing the symbol. SInce the headers all looked fine if
figured it was the database connection. So I changed the connection
to "encoding: utf8" and voila, the symbol appears correctly.
However, now when I reload the metadata the information is truncated
at the symbol (ie. on the 'Copyright ' makes it to the database.
"encoding default" i can store the right data, but not display it
"encoding: utf8" I can display the right data, but not store it.
The database is utf8, the collation is utf8-general.
Any suggestions or pointers would be much appreciated!