Ruby on Rails Friday, September 30, 2011

Use the 'pg' gem:

  gem 'pg'

And in config/database.yml:

    adapter: postgresql
    database: my_checkins_development
    host: localhost

Taken from a tutorial on my website:


Once I changed the adapter to the correct string (postgresql) it worked great.
But I ran into a slightly different question.

I'm struggling with UTF-8 encoding and was wondering if:
1) there is any real difference in postgresql between setting up en_US.UTF-8 and POSIX as far as being able to read/write anything?  I'm thinking the answer is no.
2) when rails creates this database, is there some way I can add options to this yaml file to specify the encoding when it's created?

  encoding: unicode


No comments:

Post a Comment