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?
database.yml is set properly (has been from the beginning): production: adapter: mysql encoding: utf8 On Jun 9, 12:43 pm, Mindtonic <mindto...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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?
On Jun 9, 5:48 pm, Mindtonic <mindto...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 <mindto...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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?