Re: [SQL] Changing character set when the damage is done

2006-12-22 Thread Ragnar
On lau, 2006-12-23 at 00:12 +0100, Alexis Paul Bertolini wrote: > I set up a DB with default values and it now uses the SQL_ASCII > character set (as per "show client_encoding;"). > > I have copied in quite a lot of data from various Access databases but > only now have I realized that all acce

[SQL] Changing character set when the damage is done

2006-12-22 Thread Alexis Paul Bertolini
Dear all, I set up a DB with default values and it now uses the SQL_ASCII character set (as per "show client_encoding;"). I have copied in quite a lot of data from various Access databases but only now have I realized that all accented vowels show up differently from what I expected (I dare