Re: Character set issue ( maybe )

[Daniel Kasak]

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 (&#8222;).

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: ([phone] / F: ([phone]
email: dkasak@stripped
website: http://www.nusconsulting.com.au