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.
