At 10.49 +0100 2008-02-04, Jan Pieter Kunst wrote: >2008/2/4, beat.beer <[EMAIL PROTECTED]>: >> Hi everybody >> >> I have a real nasty problem. I am upgrading some site to a new server >> with mysql 5. the site so far where in mysql 3.12. So the problem is >> that mysql 5 is in utf8 so I need to upgrade all the db's. >> Is there a smart way to accomplish this task with BBEdit? I tried it >> with iconv but all the special characters like é à é or ö ä ü are a >> mess. > >I wouldn't use BBEdit here. >I would do everything in MySQL: >- set the character set of the new, empty db to the same as the old db; >- import the old db; >- change the character set of the new db to utf8.
At the last step in MySQL I take it you mean ALTER TABLE CONVERT TO CHARACTER SET not just ALTER TABLE DEFAULT CHARACTER SET. Those have different effects. http://dev.mysql.com/doc/refman/5.1/en/alter-table.html -- Johan Sölve [FSA Member, Lasso Partner] Web Application/Lasso/FileMaker Developer MONTANIA SOFTWARE & SOLUTIONS http://www.montania.se mailto:[EMAIL PROTECTED] (spam-safe email address, replace '-' with 'a') -- ------------------------------------------------------------------ Have a feature request? Not sure the software's working correctly? If so, please send mail to <[EMAIL PROTECTED]>, not to the list. List FAQ: <http://www.barebones.com/support/lists/bbedit_talk.shtml> List archives: <http://www.listsearch.com/BBEditTalk.lasso> To unsubscribe, send mail to: <[EMAIL PROTECTED]>
