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
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
