CODEWITHSUNDEEP
ruby-on-railsactiverecordutf-8yamlserialization
Leonid Shevtsov
Leonid Shevtsov

Reputation: 14189

Ruby on Rails :serialize UTF8 problem

When I serialize a hash containing UTF8 strings, like this:

  poll.variants = {0 => 'тест',1 => '-тест-',2 => 'test # test "тест'}

to an ActiveRecord field, the resulting field contains: 

--- 
0: !binary |
  0YLQtdGB0YI=

1: !binary |
  LdGC0LXRgdGCLQ==

2: !binary |
  dGVzdCAjIHRlc3QgItGC0LXRgdGC

The utf8 strings get treated as binary and base64 encoded for some reason. The collation on the field is utf8_general_ci, and I'm a bit disappointed.

Is there any way to make ActiveRecord :serialize human-readable yaml to the field?

Upvotes: 4

Views: 2367

Answers (1)

Cody Caughlan
Cody Caughlan

Reputation: 32758

Is there any way to make ActiveRecord :serialize human-readable yaml to the field?

No. Its Base64 encoded so as to encode arbitrary text (in any encoding) down to the lowest common denonimator, which is then safe to send across the wire and/or store in datastores that dont accept UTF-8 data.

Upvotes: 5

Related Questions