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 symbol \251).
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.
Summary: "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!
Cheers, --Kip