I have solved the problem. It was a simple problem, but its cause was rather involved so I will try and explain the process and knowledge I gained in solving it below:-
I first solved it on my home computer copy of my website (which I have now re-written the website in ROR 3 and Ruby1.9.2, but that will be another thread.) I wrote a my.cnf file in my ./etc folder. I thought that that was part of the cure, but as I did not restart my server it did not have any effect until the following day when I restarted and my local copy did not start for two reasons. One was that Mysql server on my computer had stopped and (/tmp/mysql.sock) disappeared. I had to go to the preferences and restart it. The other was that both ports were set to 3000 in my my.cnf file. copy below:- [client] port = 3000 socket = /tmp/mysql.sock default-character-set=utf8 [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking init_connect='SET collation_connection = utf8_general_ci' init_connect='SET NAMES utf8' default-character-set=utf8 character-set-server = utf8 collation-server = utf8_general_ci [mysql] default-character-set=utf8 I think what cured it was setting encoding utf8 in my database.yml. copy below:- development: adapter: mysql database: donsgarden username: root password: socket: /tmp/mysql.sock encoding: utf8 I then went to my shared host and asked them to change mysql to utf8 (which they could not do) so I am stuck with Latin1 and collation Latin1_swedish_ci : I then found out that phpMyAdmin was reporting my settings wrongly, because it only uses utf8 it only reports utf8 and collation utf8_general_ci even though Mysql was using Latin1 and collation Latin1_swedish_ci throughout. (This caused a lot of head scratching) The following day my website crashed and my host moved it to a new service and all was magically solved. I think what happened was that when it restarted the encoding: utf8 in the database.yml kicked in. On my shared host my.cnf file was not changed. The only problem is that old data saved in my database is printed incorrectly, but new data entered in phpMyAdmin is saved and printed correctly. Perhaps if I changed my.cnf on my shared host (via ssh access) to include utf8 all the data (old and new as on my home copy) would print correctly. I am leaving things as they are as I can live with re-saving the little old data I have Don On Sep 15, 6:10 am, Marnen Laibow-Koser <[email protected]> wrote: > Don Mapp wrote: > > In time I will re-write in html 5, but when I originally wrote the > > website years ago I do not think 4 0r 5 was available. > > I'd be surprised. HTML 5 is recent, but I think HTML 4 predates XHTML. > > Best, > -- > Marnen Laibow-Koserhttp://www.marnen.org > [email protected] > > Sent from my iPhone > -- > 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.
