Re: HTML-Parser: storing into a DB words with special chars
thomas Armstrong <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.lwp |
|---|---|
| Message-ID | <[email protected]> |
Hi Bjoern. Thank you very much for your answer. I have no idea about how MySQL stores data, but if I do it by hand (via PHPMyAdmin) it works. And if I print the Perl program results on a TXT file, it shows right characters. I'm going to post it to a MySQL mailing list. Regards. 2005/9/21, Bjoern Hoehrmann <[email protected]>: > * thomas Armstrong wrote: > >The document contains special characters ('música española' for instance), and > >after storing it into de DB, I get this word: "música española" > > How do you "get" it? You need to ensure that the database software > supports Unicode, that you properly store the data, and that you > properly retrieve and view the data. The string above is UTF-8 but > interpreted as in some other encoding (Windows-1252 or ISO-8859-1 > for example). That's not a HTML::Parser issue. > -- > Björn Höhrmann · mailto:[email protected] · http://bjoern.hoehrmann.de > Weinh. Str. 22 · Telefon: +49(0)621/4309674 · http://www.bjoernsworld.de > 68309 Mannheim · PGP Pub. KeyID: 0xA4357E78 · http://www.websitedev.de/ >