Hi there,

it is possible now to run Ruby 1.9.1 with Squel and PostgreSQL and use
UTF-8 encoding?

The problem is that I can easily force UTF to be written into the
database (when running "pg" gem, ruby1.9 -U -E utf-8 ...), but Sequel
interprets all strings as ASCII-8BIT when fetching them back. When
doing force_encoding('utf-8') strings are back ok.

try to run the following with e.g. irb1.9 -U -E utf-8:

require 'sequel'

# connect to any database

s = DB["SELECT 'ąść' AS string"].first[:string]
puts s.encoding # => 'ASCII-8BIT'
puts s # this can fail, or produces garbage
s.force_encoding!('utf-8')
puts s # => 'ąść'

Any idea how to fix it? Needless to say, multi-encoding in Ruby 1.9
somehow sucks.

Thanks - Michal
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to