Thanks Colin That's what my son is hitting me over the head with. He dosn't want to help as he said I should have used ROR to enter the data, which should have avoided all these problems. Mind you If I had done that I would not have learned so much about Encoding. When I re-write in ROR 3 and Ruby 1.9.x I plan to do that. Don
On Sep 20, 11:49 am, Colin Law <[email protected]> wrote: > On 20 September 2010 11:45, MDM <[email protected]> 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. > > > 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) > > > 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. 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 > > > 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. > > If the only remaining problem is phpmyadmin then a better solution may > be to provide some simple admin pages on your website for entering the > data, and forget about phpmyadmin. > > Colin -- 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.
