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.

JP

--
------------------------------------------------------------------
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]>

Reply via email to