How to use SQL_ASCII encoding in a rails application?

Question

I have to connect to a legacy postgres database which has ENCODING = 'SQL_ASCII';.

How do I set this encoding in my rails app?

Answer 1

You can set this in your database.yml:

development:
  adapter: postgresql
  encoding: sql_ascii
  database: appname_development
  username: root
  password:
  host: localhost