Re: [GENERAL] Encoding questions

2007-07-08 Thread Michael Glaesemann
On Jul 8, 2007, at 14:09 , Pat Maddox wrote: Can I just convert it, or do I need to dump it, drop it, recreate with UTF-8, and then load the data? It depends on what is currently in your (SQL_ASCII) database. If it's only ASCII data or all non-ASCII data is UTF-8, you should be okay just

[GENERAL] Encoding questions

2007-07-08 Thread Pat Maddox
My databases all have the default SQL_ASCII encoding. I read the docs and it says that you shouldn't use it if you're going to have any non-ASCII data. I need to start supporting UTF-8, so it seems I need to convert my database. Can I just convert it, or do I need to dump it, drop it, recreate