BÁRTHÁZI András wrote:
Hi Daniel,
I'm trying to copy & paste some data from a web page into MySQL ( and
How do you mean "pasting into MySQL"? Which program do you use on the
destination side?
Query browser *and* an in-house Perl Gtk2 app both produce the same
results. I'm pretty sure I mentioned them both throughout my original post.
You can use clipboard to copy into mysql (the console application),
phpMyAdmin, some visual program, etc.
Anyway, if your database is iso-8859-1 / iso-8859-2 (Latin1 / Latin2)
coded, you won't really able to store euro sign and special quotes
with it, as Latin character sets just contains <255 different
characters and special quotes are not in these characters. You should
use utf-8, or you can store these characters as HTML encodings („).
I've also tried utf-8 now, both with Query Browser and our Perl Gtk2
app. This also produces exactly the same results. I can't go back to
using the mysql console, as other people have to be able to do this, and
they require a GUI.
--
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: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]