473,320 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Storing Spanish words from an XML parse

Hello.

I'm parsing an XML file, and trying to store its contents
into a MySQL database.

But I've got problems. If I print the word before storing
it, I get 'música' (OK). But if I store it and make a
'SELECT', I get 'música' (wrong).

I use Perl (with 'XML::Parser' module). Does anybody have
any experience? Thank you very much.
Jul 19 '05 #1
8 2907
Try using BLOB

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...
Hello.

I'm parsing an XML file, and trying to store its contents
into a MySQL database.

But I've got problems. If I print the word before storing
it, I get 'música' (OK). But if I store it and make a
'SELECT', I get 'música' (wrong).

I use Perl (with 'XML::Parser' module). Does anybody have
any experience? Thank you very much.

Jul 19 '05 #2
Try using BLOB

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...
Hello.

I'm parsing an XML file, and trying to store its contents
into a MySQL database.

But I've got problems. If I print the word before storing
it, I get 'música' (OK). But if I store it and make a
'SELECT', I get 'música' (wrong).

I use Perl (with 'XML::Parser' module). Does anybody have
any experience? Thank you very much.

Jul 19 '05 #3
Problem is in your charset, looks like your xml file is in utf-8 and
MySQL doesn't suport it. No problem you don't need to use blob. In
MySQL, characters like ú will be stored as two simbols (ú -> ú), just
make sure that when you view data on your web page you set the charset
to utf-8. In head put:
<meta http-equiv="content-type" content="text/html;charset=utf-8">

"jackson marshmallow" <jm**********@yahoo.com> wrote in message news:<Iy******************@newssvr29.news.prodigy. com>...
Try using BLOB

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...
Hello.

I'm parsing an XML file, and trying to store its contents
into a MySQL database.

But I've got problems. If I print the word before storing
it, I get 'música' (OK). But if I store it and make a
'SELECT', I get 'música' (wrong).

I use Perl (with 'XML::Parser' module). Does anybody have
any experience? Thank you very much.

Jul 19 '05 #4
Problem is in your charset, looks like your xml file is in utf-8 and
MySQL doesn't suport it. No problem you don't need to use blob. In
MySQL, characters like ú will be stored as two simbols (ú -> ú), just
make sure that when you view data on your web page you set the charset
to utf-8. In head put:
<meta http-equiv="content-type" content="text/html;charset=utf-8">

"jackson marshmallow" <jm**********@yahoo.com> wrote in message news:<Iy******************@newssvr29.news.prodigy. com>...
Try using BLOB

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...
Hello.

I'm parsing an XML file, and trying to store its contents
into a MySQL database.

But I've got problems. If I print the word before storing
it, I get 'música' (OK). But if I store it and make a
'SELECT', I get 'música' (wrong).

I use Perl (with 'XML::Parser' module). Does anybody have
any experience? Thank you very much.

Jul 19 '05 #5
But I'm not talking about web pages. I want only to store the
words into mySQL, and then I want to handle them. I do not
want to show them on a website.

ma****@volja.net (lazo) wrote in message news:<97*************************@posting.google.c om>...
Problem is in your charset, looks like your xml file is in utf-8 and
MySQL doesn't suport it. No problem you don't need to use blob. In
MySQL, characters like ú will be stored as two simbols (ú -> ú), just
make sure that when you view data on your web page you set the charset
to utf-8. In head put:
<meta http-equiv="content-type" content="text/html;charset=utf-8">

"jackson marshmallow" <jm**********@yahoo.com> wrote in message news:<Iy******************@newssvr29.news.prodigy. com>...
Try using BLOB

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...
Hello.

I'm parsing an XML file, and trying to store its contents
into a MySQL database.

But I've got problems. If I print the word before storing
it, I get 'música' (OK). But if I store it and make a
'SELECT', I get 'música' (wrong).

I use Perl (with 'XML::Parser' module). Does anybody have
any experience? Thank you very much.

Jul 19 '05 #6
But I'm not talking about web pages. I want only to store the
words into mySQL, and then I want to handle them. I do not
want to show them on a website.

ma****@volja.net (lazo) wrote in message news:<97*************************@posting.google.c om>...
Problem is in your charset, looks like your xml file is in utf-8 and
MySQL doesn't suport it. No problem you don't need to use blob. In
MySQL, characters like ú will be stored as two simbols (ú -> ú), just
make sure that when you view data on your web page you set the charset
to utf-8. In head put:
<meta http-equiv="content-type" content="text/html;charset=utf-8">

"jackson marshmallow" <jm**********@yahoo.com> wrote in message news:<Iy******************@newssvr29.news.prodigy. com>...
Try using BLOB

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...
Hello.

I'm parsing an XML file, and trying to store its contents
into a MySQL database.

But I've got problems. If I print the word before storing
it, I get 'música' (OK). But if I store it and make a
'SELECT', I get 'música' (wrong).

I use Perl (with 'XML::Parser' module). Does anybody have
any experience? Thank you very much.

Jul 19 '05 #7
As I wrote is with web pages, other experiences I don't have with
MySQL, try to look at www.mysql.com, I think that last version support
also utf-8
fr**********@europe.com (Francesco Moi) wrote in message news:<5b**************************@posting.google. com>...
But I'm not talking about web pages. I want only to store the
words into mySQL, and then I want to handle them. I do not
want to show them on a website.

ma****@volja.net (lazo) wrote in message news:<97*************************@posting.google.c om>...
Problem is in your charset, looks like your xml file is in utf-8 and
MySQL doesn't suport it. No problem you don't need to use blob. In
MySQL, characters like ú will be stored as two simbols (ú -> ú), just
make sure that when you view data on your web page you set the charset
to utf-8. In head put:
<meta http-equiv="content-type" content="text/html;charset=utf-8">

"jackson marshmallow" <jm**********@yahoo.com> wrote in message news:<Iy******************@newssvr29.news.prodigy. com>...
Try using BLOB

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...
> Hello.
>
> I'm parsing an XML file, and trying to store its contents
> into a MySQL database.
>
> But I've got problems. If I print the word before storing
> it, I get 'música' (OK). But if I store it and make a
> 'SELECT', I get 'música' (wrong).
>
> I use Perl (with 'XML::Parser' module). Does anybody have
> any experience? Thank you very much.

Jul 19 '05 #8
As I wrote is with web pages, other experiences I don't have with
MySQL, try to look at www.mysql.com, I think that last version support
also utf-8
fr**********@europe.com (Francesco Moi) wrote in message news:<5b**************************@posting.google. com>...
But I'm not talking about web pages. I want only to store the
words into mySQL, and then I want to handle them. I do not
want to show them on a website.

ma****@volja.net (lazo) wrote in message news:<97*************************@posting.google.c om>...
Problem is in your charset, looks like your xml file is in utf-8 and
MySQL doesn't suport it. No problem you don't need to use blob. In
MySQL, characters like ú will be stored as two simbols (ú -> ú), just
make sure that when you view data on your web page you set the charset
to utf-8. In head put:
<meta http-equiv="content-type" content="text/html;charset=utf-8">

"jackson marshmallow" <jm**********@yahoo.com> wrote in message news:<Iy******************@newssvr29.news.prodigy. com>...
Try using BLOB

"Francesco Moi" <fr**********@europe.com> wrote in message
news:5b**************************@posting.google.c om...
> Hello.
>
> I'm parsing an XML file, and trying to store its contents
> into a MySQL database.
>
> But I've got problems. If I print the word before storing
> it, I get 'música' (OK). But if I store it and make a
> 'SELECT', I get 'música' (wrong).
>
> I use Perl (with 'XML::Parser' module). Does anybody have
> any experience? Thank you very much.

Jul 19 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Mark | last post by:
I have a website with an increasing amount of articles and news reports and so I am thinking of moving away from storing each article as a seperate page to having a single page and storing articles...
3
by: dave | last post by:
Hello there, I am at my wit's end ! I have used the following script succesfully to upload an image to my web space. But what I really want to be able to do is to update an existing record in a...
5
by: Richie Adler | last post by:
Does anyone know of a bitmap/resource/image collection for a Spanish card deck? I'm planning to create a new cardgame which requires this kind of deck (prototyping in Python and possible final...
4
by: meldrape | last post by:
Hello, I need to parse a long string into no more than 30 character chunks, but I also need to leave the words intact. Right now, I am using: For intStart = 1 to Len(strOriginal) by 30...
6
by: Francesco Moi | last post by:
Hello. I'm trying to store UTF-8 texts into a mySQL database. These texts contains Spanish special characters. If I set field as VARCHAR and browse stored data, I get 'año' instead of 'año'....
7
by: solartimba | last post by:
I need to read Spanish words from a file and print them to the screen. Is there a C++ header file that allows foreign words? Is the problem C or the OS? (I am the only person that will use this...
10
by: jim_adams | last post by:
I need a very efficient way to parse large amounts of text (GBs) on word boundaries. Words will then be added to an array as long as they haven't already been added. Splitting on a space is a bit...
5
by: Frederik Van Bogaert | last post by:
Hi! I've taken my first steps into the world of c++ by trying to write a text adventure game. Things are proceeding fine, but there's some code in there that isn't very well coded. More...
2
by: DCDeshpande | last post by:
Hi, I am new to Java and need to parse a simple txt file into unique tokens and store them in a data structure. Can someone please recommend the most efficient way to do this? I found out that...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.