Character set issue ( maybe )

[Daniel Kasak]

Greetings.

I'm trying to copy & paste some data from a web page into MySQL ( and 
yes it's our data ). I'm getting problems with characters such as 
quotes, dollar / euro signs, etc, that won't import - I get symbols and 
stuff instead.

If I right-click on the web page and select 'View Page Info', the dialog 
that appears tells me that the web page is using:

Content-Type: text/html; charset=iso8859-1

I've searched on 8859-1 and it's 'Latin'. My MySQL ( 4.1.14 ) table was 
using the 'default' character set. I've had a look at the list of 
options in MySQL-Administrator, and there's no 'Latin' or 8859-1. I've 
got an 8859-2, so I tried that ... no luck. I've also tried using 
MySQL-Query-Browser, and my own home-grown Perl Gtk2 front-end to the 
tables - both produce exactly the same results.

I'm using the latest version of Query Browser, and with my home-grown 
effort, I'm using DBD-mysql-2.9007, compiled against 
mysql-5.0.something. I've got gtk+-2.8.6.

Anyone got any ideas? Is this a Gtk2 problem ( Query Browser and my app 
are using Gtk2 ), or is it a driver issue, or a table issue?

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: ([phone] / F: ([phone]
email: dkasak@stripped
website: http://www.nusconsulting.com.au