Forum: Ruby on Rails Copyright (c) symbol, mysql and utf8

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
9347d4d9f9c4272f6a3297ea3a5976ac?d=identicon&s=25 Kip (Guest)
on 2007-07-23 06:59
(Received via mailing list)
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.

  "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
This topic is locked and can not be replied to.