[Rails] Re: Issues with MySql database encoding

2009-06-09 Thread Freddy Andersen

How was the database created? Through MySQL SQL import? Does the sql
have 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@googlegroups.com
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~--~~~~--~~--~--~---



[Rails] Re: Issues with MySql database encoding

2009-06-09 Thread Frederick Cheung



On Jun 9, 5:48 pm, Mindtonic  wrote:
> database.yml is set properly (has been from the beginning):
>
> production:
>   adapter: mysql
>   encoding: utf8
>
Are the encodings for the various columns set properly?

Fred
> On Jun 9, 12:43 pm, Mindtonic  wrote:
>
>
>
> > Hello, I am working on an international project that requires UTF-8
> > encoding for letter characters.  I have successfully changed my local
> > development machine to UTF-8 and all characters are holding as they
> > should.  However, my production server is a Solaris box, and it is not
> > holding the proper characters even after I change the database
> > encoding.
>
> > I would prefer not to use htmlentites as it can be quite messy and
> > does not yield an accurate search result.
>
> > Does anyone have any suggestions?
--~--~-~--~~~---~--~~
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@googlegroups.com
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~--~~~~--~~--~--~---



[Rails] Re: Issues with MySql database encoding

2009-06-09 Thread Mindtonic

database.yml is set properly (has been from the beginning):

production:
  adapter: mysql
  encoding: utf8

On Jun 9, 12:43 pm, Mindtonic  wrote:
> Hello, I am working on an international project that requires UTF-8
> encoding for letter characters.  I have successfully changed my local
> development machine to UTF-8 and all characters are holding as they
> should.  However, my production server is a Solaris box, and it is not
> holding the proper characters even after I change the database
> encoding.
>
> I would prefer not to use htmlentites as it can be quite messy and
> does not yield an accurate search result.
>
> Does anyone have any suggestions?
--~--~-~--~~~---~--~~
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@googlegroups.com
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en
-~--~~~~--~~--~--~---