New to rails - apparently need patch to use PostgreSQL

Help please. My first attempt at Rails, I'm trying to use PostgreSQL
and I'm seeing this error. I'm also new to PostgreSQL, but the
default encoding in PostgreSQL appears to be SQL_ASCII. I'm not sure
if I should try and get the patch or try and change the PostgreSQL
template. Sorry I'm so confused. FWIW, I've been a .NET MSSQL
developer and want to get up to speed on Rails with PostgreSQL.

Thanks.

https://rails.lighthouseapp.com/projects/8994/tickets/4304-cannot-set-postgres-adapter-encoding-to-anything-besides-utf-8

cootcraig wrote:

Help please. My first attempt at Rails, I'm trying to use PostgreSQL
and I'm seeing this error. I'm also new to PostgreSQL, but the
default encoding in PostgreSQL appears to be SQL_ASCII.

You should always use UTF8 for your database. If you do that, you'll be
able to handle any text, and this bug should not affect you.

I'm not sure
if I should try and get the patch

Perhaps.

or try and change the PostgreSQL
template.

Change the template. There is no reason to have your DB set to ASCII N

Sorry I'm so confused.

What are you confused by?

FWIW, I've been a .NET MSSQL
developer and want to get up to speed on Rails with PostgreSQL.

Good choice!

Thanks.

https://rails.lighthouseapp.com/projects/8994/tickets/4304-cannot-set-postgres-adapter-encoding-to-anything-besides-utf-8

Best,

You’re using PostgreSQL on Ubuntu, right?

Actually my development server is FreeBSD. My workstation is Vista 64
and I'm using VirtualBox to run 2 VM's: FreeBSD as the server with
PostgreSQL,Apache,Rails. Ubuntu as a client.

I plan to reinstall PostgreSQL setting the template encoding to UTF8

I guess I'm not so much confused as slogging through learning a lot of
setup before I dig into Ruby and Rails, my own choice.

After reinstalling PostgreSQL, using initdb to set the template
encoding to UTF8
rake db:create
in fact creates a database.

Now, time to learn some rails.