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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Marnen Laibow-Koser
2010-Apr-24 13:27 UTC
Re: New to rails - apparently need patch to use PostgreSQL
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 patchPerhaps.> 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-8Best, -- Marnen Laibow-Koser http://www.marnen.org marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Joshua Martin
2010-Apr-24 15:11 UTC
Re: Re: New to rails - apparently need patch to use PostgreSQL
You''re using PostgreSQL on Ubuntu, right? On Sat, Apr 24, 2010 at 9:27 AM, Marnen Laibow-Koser <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>wrote:> 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 > marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org > -- > Posted via http://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > 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. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
cootcraig
2010-Apr-24 15:43 UTC
Re: New to rails - apparently need patch to use PostgreSQL
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. On Apr 24, 9:11 am, Joshua Martin <josmar52...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> You''re using PostgreSQL on Ubuntu, right? > > On Sat, Apr 24, 2010 at 9:27 AM, Marnen Laibow-Koser > <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>wrote: > > > > > > > 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... > > > Best, > > -- > > Marnen Laibow-Koser > >http://www.marnen.org > > mar...-sbuyVjPbboAdnm+yROfE0A@public.gmane.org > > -- > > Posted viahttp://www.ruby-forum.com/. > > > -- > > You received this message because you are subscribed to the Google Groups > > "Ruby on Rails: Talk" group. > > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > > To unsubscribe from this group, send email to > > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > > . > > 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. > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. > For more options, visit this group athttp://groups.google.com/group/rubyonrails-talk?hl=en.- Hide quoted text - > > - Show quoted text --- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
cootcraig
2010-Apr-25 15:48 UTC
Re: New to rails - apparently need patch to use PostgreSQL
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. On Apr 24, 9:43 am, cootcraig <cootcr...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> 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. > > On Apr 24, 9:11 am, Joshua Martin <josmar52...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > > > > You''re using PostgreSQL on Ubuntu, right? > > > On Sat, Apr 24, 2010 at 9:27 AM, Marnen Laibow-Koser > > <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org>wrote: > > > > 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... > > > > Best, > > > -- > > > Marnen Laibow-Koser > > >http://www.marnen.org > > > mar...-sbuyVjPbboAdnm+yROfE0A@public.gmane.org > > > -- > > > Posted viahttp://www.ruby-forum.com/. > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "Ruby on Rails: Talk" group. > > > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh4Ykp1iOSErHA@public.gmane.orgm. > > > To unsubscribe from this group, send email to > > > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > > > . > > > 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. > > > -- > > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > > For more options, visit this group athttp://groups.google.com/group/rubyonrails-talk?hl=en.-Hide quoted text - > > > - Show quoted text - > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. > For more options, visit this group athttp://groups.google.com/group/rubyonrails-talk?hl=en.- Hide quoted text - > > - Show quoted text --- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.