New to rails - apparently need patch to use PostgreSQL

Rails
#1

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

#2

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,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]

#3

You’re using PostgreSQL on Ubuntu, right?

On Sat, Apr 24, 2010 at 9:27 AM, Marnen Laibow-Koser
[email protected]wrote:

“Ruby on Rails: Talk” group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected][email protected]
.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

–

Joshua S. Martin

CONFIDENTIALITY NOTE: This e-mail message, including any attachment(s),
contains information that may be confidential, protected by the attorney
client or other legal privileges, and or proprietary non public
information.
If you are not an intended recipient of this message or an authorized
assistant to an intended recipient, please notify the sender by replying
to
this message and then delete it from your system. Use, dissemination,
distribution, or reproduction of this message and or any of its
attachments
(if any) by unintended recipients is not authorized and may be unlawful.

#4

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.

#5

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.