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.
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.
#4304 Cannot set postgres adapter encoding to anything besides utf-8 - Ruby on Rails - rails
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.