On Fri, 14 Jul 2006 13:55:52 -0500, Robert Boone wrote:
> Is there any way to detect the real character set use in columns? I've
> just seen a mysql 4.0 database where the default character set was
> latin1 but greek was being inserted. When that database was upgraded to
> 4.1 the greek became unreadable. So I guess I'm asking how can I detect
> this so I can run a process on suspected databases and ALTER them to
> the correct character set.

Put data into it, pull it back out, and compare the results to the input
data?

--
"It's 106 light-years to Chicago, we've got a full chamber of anti-matter,
a half a pack of cigarettes, it's dark, and we're wearing visors."
"Engage."