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?

Mike Breen · Accepted Answer · 2008-10-27 19:47:46Z

3

You can set this in your database.yml:

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

answered Oct 27, 2008 at 19:47

Mike Breen

2,6101 gold badge19 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Scott Bartell Over a year ago

Note: Order seems to matter: make sure your encoding is specified before your database name - this is what appears to have been causing the error for me.

Collectives™ on Stack Overflow

How to use SQL_ASCII encoding in a rails application?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related