Thanks guys for all the support and advice. Yep I would have preferred to use UFT8 and if I did do another ROR project I would do it differently, But having started learning ROR a few years ago I have gradually built up the website piecemeal. And At the mo I am still a relative newbie and sometimes it is better the devil you know. One day when I have time I will re-write the whole project and look for a different host. Ruby 1.9.2 and Ruby on Rails 3 beckon soon. I still think 1.9.2 needs a little settling down. Anyway now I am this far I want to solve this the hard way. That way I will learn so much more about these various technologies. Don
On Sep 20, 3:19 pm, Marnen Laibow-Koser <[email protected]> wrote: > Don Mapp wrote: > > I thought you might be interested in how far I have got with solving > > my problem with MySql(via phpMyAdmin) to website character_set > > problems. > > Why did you start a new thread and make it harder to refer to the > original problem? > > For reference, the old thread is athttp://www.ruby-forum.com/topic/216878. > > > > > I thought I had solved the problem when my characters on my website > > started showing the special characters. > > > This was a partial success though. > > > When I went back to phpMyAdmin and entered new text the problem was > > the same, but reversed. What now happens is that the original text I > > typed is now converted to gibberish(Latin1 to UTF8) > > UTF8 is what you want to be using. > > > > > and new text entered, in phpMyAdmin, is output to website as "?" > > again > > See:- > > >http://donsgarden.co.uk/pests/228?telephone=2 > > > What I did, as I could not change the server Craracter_set and > > Collation (Shared Server). I got my host to change everything back to > > Latin1. > > Wait, wait, wait, wait. Why are you using a shared host (not generally > a great idea for Rails)? Worse, why are you using a host that doesn't > let you change your own DB charset settings? Even shared hosting should > let you do that. If not, find another hosting provider. > > I was going to change my w/site meta line to ISO 8859-1. > > > > > From connecting to my database via ssh I got:- > > > mysql> show variables like 'c%'; > > +--------------------------+----------------------------+ > > | Variable_name | > > Value | > > +--------------------------+----------------------------+ > > | character_set_client | > > latin1 | > > | character_set_connection | latin1 | > > | character_set_database | latin1 > > | > > | character_set_filesystem | binary > > | > > | character_set_results | > > latin1 | > > | character_set_server | > > latin1 | > > | character_set_system | > > utf8 | > > | character_sets_dir | /usr/share/mysql/charsets/ | > > | collation_connection | latin1_swedish_ci > > | > > | collation_database | latin1_swedish_ci > > | > > | collation_server | > > latin1_swedish_ci | > > | completion_type | > > 0 | > > | concurrent_insert | > > 1 | > > | connect_timeout | > > 10 | > > +--------------------------+----------------------------+ > > 14 rows in set (0.00 sec) > > > Great I thought, but when I use phpMyAdmin to issue the same command I > > got:- > > > show variables like 'c%'; > > > Variable_name Value > > character_set_client utf8 > > character_set_connection utf8 > > character_set_database latin1 > > character_set_filesystem binary > > character_set_results utf8 > > character_set_server latin1 > > character_set_system utf8 > > character_sets_dir /usr/share/mysql/charsets/ > > collation_connection utf8_general_ci > > collation_database latin1_swedish_ci > > collation_server latin1_swedish_ci > > completion_type 0 > > concurrent_insert 1 > > connect_timeout 10 > > Yuck! That's really inconsistent. Change it all to UTF-8. > > > > > Perhaps when I sort this out I will reach my ultimate goal of entering > > text in phpMyAdmin and having it displayed on my website correctly. > > I agree with Colin -- don't worry too much about phpMyAdmin. Worry > about the actual DB. If you want to build an admin tool quickly, try > ActiveScaffold. > > And follow the advice in the older thread. It will stand you in better > stead than what you've actually done. > > > > > Many thanks for all the help it has got me this far and now I have > > hope I will solve the problem in the end. > > You will -- if you actually *take* the advice given to you. :) > > > Don > > Best, > -- > Marnen Laibow-Koserhttp://www.marnen.org > [email protected] > -- > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
