ASCII character encoding means that the database does not care about the encoding. So it is the responsibility of the programs you use, to use the correct encoding for your application. So you need to know the used encoding of your applications/data in your database. Then you can convert a text backup by recode, iconv or anything like that to utf8. You should be able to restore the corrected dump into a utf8 database. If your applications used different encodings you have to fix this somehow by hand first. In chapter 22 of the manual you can find more details about encodings. Best regards Ivo Am Freitag, 30. Mai 2008 15:45:25 schrieb Campbell, Lance: > I have a database that is in ASCII character encoding. How do I go > about migrating it to UTF8? > > > > Thanks, > > > > Lance Campbell > > Project Manager/Software Architect > > Web Services at Public Affairs > > University of Illinois > > 217.333.0382 > > http://webservices.uiuc.edu > > My e-mail address has changed to lance@xxxxxxxxxxxx
