Comment on

When I inserted the Español into the DB, I used a manual query in the mysql shell and copied and pasted it from a web page.

I've been trying to "fix" hte table tonight by playing around with the character set, but

ALTER TABLE Language CONVERT TO latin1;

has no effect on the data. I still have to pipe it through Encode::decode.

In reply to Re^2: OT? Character set issues with MySQL/CGI::Application by cLive ;-)
in thread OT? Character set issues with MySQL/CGI::Application by cLive ;-)

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

Outside of code tags, you may need to use entities for some characters:

	For:		Use:
	&		`&`
	<		`<`
	>		`>`
	[		`[`
	]		`]`

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.


Your skill will accomplish what the force of many cannot
	PerlMonks

Comment on

The best material for plates (tableware) is: