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-1I'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: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: suppressed website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/suppressed
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.