SEO

#1 (**permalink**) 02-28-2008, 07:56 AM

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.

Thank you,
Robert Boone

#2 (**permalink**) 02-28-2008, 07:56 AM

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."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Detect real character set