Click here to get back home

HTML-Parser: storing into a DB words with special chars

 HomeNewsGroups | Search | About
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
HTML-Parser: storing into a DB words with special chars tarmstrong 09-21-2005
Get Chitika Premium
Posted by tarmstrong on September 21, 2005, 2:40 am
Please log in for more thread options


Hi.

Using Perl v5.8.5 + HTML-Parser v3.45 + MySQL v4.1.9 on Linux FC2.

I'm trying to parse a UTF-8 document (<?xml version="1.0"
encoding="UTF-8"?>),
and store it into a MySQL database (Collation: utf8_bin).

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"

I tried with:
----
utf8::decode($document);
my $p = HTML::TokeParser->new( $document );
----

But it doesn't work. How can I store words with special characters?
Regards.



Similar ThreadsPosted
words selection September 2, 2006, 10:43 am
Storing multiple cookies June 9, 2007, 11:58 am
DBI problem -- storing large value into an INT8 field January 4, 2007, 10:28 am
Re: XML::Simple XMLIn() and odd chars August 3, 2008, 11:07 pm
translate unicode chars hexadecimal encoded to iso-8859-1 February 2, 2006, 7:31 am
translate unicode chars hexadecimal encoded to iso-8859-1 February 2, 2006, 7:31 am
Spreadsheet::Read special characters handling November 20, 2006, 2:33 am
searching for module providing menus with special abilities October 25, 2004, 11:13 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap