You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Antonio Gallardo Rivera <ag...@agsoftware.dnsalias.com> on 2002/08/29 09:57:50 UTC
How to encode ISO-8859-1 characters into the Database?
I am using PostgreSQL 7.2.1
If I store a string value, like "Olé" in the Database without using Cocoon. I
can get it back. Without any problem. It is stored correctly. But, In Cocoon
2.03 (Tomcat 4.1.9)
I need to store values to the Database like "Olé". I saw that the Cocoon
manipulate the data like UTF-8 and not in the code ISO-8859-1. How I can
change this feature to make Cocoon work in ISO-8859-1 code?
Regards,
Antonio Gallardo
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: [SUMMARY] How to encode ISO-8859-1 characters into the Database?
Posted by Barbara Post <ba...@ifrance.com>.
I guess Carsten helped me finding this out first ;-)
So thanks to every guru here :-)
Cocoon rules ;-)
----- Original Message -----
From: "Antonio Gallardo Rivera" <ag...@agsoftware.dnsalias.com>
To: <co...@xml.apache.org>
Sent: Thursday, August 29, 2002 11:25 AM
Subject: [SUMMARY] How to encode ISO-8859-1 characters into the Database?
Barbara:
Thank you Very much! It works fine now!
Antonio Gallardo
*********************************************************************
SOLUTION by Barbara Post :) :
go to the sitemap and ensure that XML and HTML serializers have the
following
tag:
<encoding>iso-8859-1</encoding>
*********************************************************************
CAUSE by Barbara Post:
Sitemap overrides XSP/XSL encoding....
*********************************************************************
PROBLEM by me :(
I create the Database now using the following string:
createdb -E LATIN1 -e mydb
Where,
LATIN1 is the encoding used by the database
mydb is the name of the database
Now When I wrote: "Olé"
When I retrieve the values there are: "Olé"
Also, I used at the beginning of the XSP pages the string:
<?xml version="1.0" encoding="ISO-8859-1"?>
What is wrong?
*********************************************************************
The first request:
PLATAFORM:
Cocoon 2.0.3
Tomcat 4.1.9
PostgreSQL 7.2.1.
PROBLEM:
If I store a string value, like "Olé" in the Database without using Cocoon.
I
retrieve it and see "Olé". The same string.
With Cocoon:
I need to store values to the Database like "Olé". I saw that the Cocoon
manipulate the data like UTF-8 and not in the code ISO-8859-1. How I can
change this feature to make Cocoon work in ISO-8859-1 code?
I hope it will help anybody :) And thanks again Barbara :)
Antonio Gallardo
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
[SUMMARY] How to encode ISO-8859-1 characters into the Database?
Posted by Antonio Gallardo Rivera <ag...@agsoftware.dnsalias.com>.
Barbara:
Thank you Very much! It works fine now!
Antonio Gallardo
*********************************************************************
SOLUTION by Barbara Post :) :
go to the sitemap and ensure that XML and HTML serializers have the following
tag:
<encoding>iso-8859-1</encoding>
*********************************************************************
CAUSE by Barbara Post:
Sitemap overrides XSP/XSL encoding....
*********************************************************************
PROBLEM by me :(
I create the Database now using the following string:
createdb -E LATIN1 -e mydb
Where,
LATIN1 is the encoding used by the database
mydb is the name of the database
Now When I wrote: "Olé"
When I retrieve the values there are: "Olé"
Also, I used at the beginning of the XSP pages the string:
<?xml version="1.0" encoding="ISO-8859-1"?>
What is wrong?
*********************************************************************
The first request:
PLATAFORM:
Cocoon 2.0.3
Tomcat 4.1.9
PostgreSQL 7.2.1.
PROBLEM:
If I store a string value, like "Olé" in the Database without using Cocoon. I
retrieve it and see "Olé". The same string.
With Cocoon:
I need to store values to the Database like "Olé". I saw that the Cocoon
manipulate the data like UTF-8 and not in the code ISO-8859-1. How I can
change this feature to make Cocoon work in ISO-8859-1 code?
I hope it will help anybody :) And thanks again Barbara :)
Antonio Gallardo
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: How to encode ISO-8859-1 characters into the Database?
Posted by Barbara Post <ba...@ifrance.com>.
go to the sitemap and first ensure that XML and HTML serializers have the
following tag :
<encoding>iso-8859-1</encoding>
What other components could be configured this way ?
It solved my problem, so it may help yours, although I don't use XSP.
Sitemap overrides XSP/XSL encoding....
Barbara
----- Original Message -----
From: "Antonio Gallardo Rivera" <ag...@agsoftware.dnsalias.com>
To: <co...@xml.apache.org>
Sent: Thursday, August 29, 2002 10:45 AM
Subject: Re: How to encode ISO-8859-1 characters into the Database?
I create the Database now using the following string:
createdb -E LATIN1 -e mydb
Where,
LATIN1 is the encoding used by the database
mydb is the name of the database
Now When I wrote: "Olé"
When I retrieve the values there are: "Olé"
Please, somebody know how to resolve this problem. I used at the beginning
of
the XSP pages the string:
<?xml version="1.0" encoding="ISO-8859-1"?>
What I am doing wrong?
Regards,
Antonio Gallardo
El Jueves, 29 de Agosto de 2002 01:57, Antonio Gallardo Rivera escribió:
> I am using PostgreSQL 7.2.1
> If I store a string value, like "Olé" in the Database without using
Cocoon.
> I can get it back. Without any problem. It is stored correctly. But, In
> Cocoon 2.03 (Tomcat 4.1.9)
>
> I need to store values to the Database like "Olé". I saw that the Cocoon
> manipulate the data like UTF-8 and not in the code ISO-8859-1. How I can
> change this feature to make Cocoon work in ISO-8859-1 code?
>
> Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: How to encode ISO-8859-1 characters into the Database?
Posted by Koen Pellegrims <ko...@pandora.be>.
> -----Oorspronkelijk bericht-----
> Van: Vadim Gritsenko [mailto:vadim.gritsenko@verizon.net]
> Verzonden: vrijdag 30 augustus 2002 16:05
> Aan: cocoon-users@xml.apache.org
> Onderwerp: Re: How to encode ISO-8859-1 characters into the Database?
>
>
> Koen Pellegrims wrote:
>
> >I don't know about Postgres, but with MySQL, you can set a
> parameter on the
> >jdbc-driver in web.xml
> >eg.:
> >
> ><jdbc name="mydb">
> > <encoding>ISO-8859-15</encoding>
> >
>
> It'd better be UTF-8. Whole XML world lives in UTF-8, and Java
> characters know nothing except UTF-8 (101 of Java char type). Thus, when
> your database returns non-UTF, of course you can do some tricks to make
> result look Ok, but this does not solve the issue.
>
> Point here is when your database, say, in ISO-8859-15, and you want
> output HTML in same encoding, then it will work. But if you ask
> serializer to use other encoding (which it can do - if input is valid),
> result will be garbage, because serializer when encoding will *assume*
> that input is UTF-8 - but it is not.
>
You're absolutely right, my bad... :-)
>
> Regards,
> Vadim
>
>
>
> > <dburl>jdbc:mysql://<server>/<db>
> ></jdbc>
> >
> >
> >
> >>-----Oorspronkelijk bericht-----
> >>Van: Antonio Gallardo Rivera [mailto:agallardo@agsoftware.dnsalias.com]
> >>Verzonden: donderdag 29 augustus 2002 10:45
> >>Aan: cocoon-users@xml.apache.org
> >>Onderwerp: Re: How to encode ISO-8859-1 characters into the Database?
> >>
> >>
> >>I create the Database now using the following string:
> >>
> >>createdb -E LATIN1 -e mydb
> >>
> >>Where,
> >>LATIN1 is the encoding used by the database
> >>mydb is the name of the database
> >>
> >>Now When I wrote: "Olé"
> >>When I retrieve the values there are: "Olé"
> >>
> >>Please, somebody know how to resolve this problem. I used at the
> >>beginning of
> >>the XSP pages the string:
> >>
> >><?xml version="1.0" encoding="ISO-8859-1"?>
> >>
> >>What I am doing wrong?
> >>
> >>Regards,
> >>
> >>Antonio Gallardo
> >>
> >>
> >>
> ...
>
>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: How to encode ISO-8859-1 characters into the Database?
Posted by Vadim Gritsenko <va...@verizon.net>.
Koen Pellegrims wrote:
>I don't know about Postgres, but with MySQL, you can set a parameter on the
>jdbc-driver in web.xml
>eg.:
>
><jdbc name="mydb">
> <encoding>ISO-8859-15</encoding>
>
It'd better be UTF-8. Whole XML world lives in UTF-8, and Java
characters know nothing except UTF-8 (101 of Java char type). Thus, when
your database returns non-UTF, of course you can do some tricks to make
result look Ok, but this does not solve the issue.
Point here is when your database, say, in ISO-8859-15, and you want
output HTML in same encoding, then it will work. But if you ask
serializer to use other encoding (which it can do - if input is valid),
result will be garbage, because serializer when encoding will *assume*
that input is UTF-8 - but it is not.
Regards,
Vadim
> <dburl>jdbc:mysql://<server>/<db>
></jdbc>
>
>
>
>>-----Oorspronkelijk bericht-----
>>Van: Antonio Gallardo Rivera [mailto:agallardo@agsoftware.dnsalias.com]
>>Verzonden: donderdag 29 augustus 2002 10:45
>>Aan: cocoon-users@xml.apache.org
>>Onderwerp: Re: How to encode ISO-8859-1 characters into the Database?
>>
>>
>>I create the Database now using the following string:
>>
>>createdb -E LATIN1 -e mydb
>>
>>Where,
>>LATIN1 is the encoding used by the database
>>mydb is the name of the database
>>
>>Now When I wrote: "Olé"
>>When I retrieve the values there are: "Olé"
>>
>>Please, somebody know how to resolve this problem. I used at the
>>beginning of
>>the XSP pages the string:
>>
>><?xml version="1.0" encoding="ISO-8859-1"?>
>>
>>What I am doing wrong?
>>
>>Regards,
>>
>>Antonio Gallardo
>>
>>
>>
...
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: How to encode ISO-8859-1 characters into the Database?
Posted by Koen Pellegrims <ko...@pandora.be>.
I don't know about Postgres, but with MySQL, you can set a parameter on the
jdbc-driver in web.xml
eg.:
<jdbc name="mydb">
<encoding>ISO-8859-15</encoding>
<dburl>jdbc:mysql://<server>/<db>
</jdbc>
> -----Oorspronkelijk bericht-----
> Van: Antonio Gallardo Rivera [mailto:agallardo@agsoftware.dnsalias.com]
> Verzonden: donderdag 29 augustus 2002 10:45
> Aan: cocoon-users@xml.apache.org
> Onderwerp: Re: How to encode ISO-8859-1 characters into the Database?
>
>
> I create the Database now using the following string:
>
> createdb -E LATIN1 -e mydb
>
> Where,
> LATIN1 is the encoding used by the database
> mydb is the name of the database
>
> Now When I wrote: "Olé"
> When I retrieve the values there are: "Olé"
>
> Please, somebody know how to resolve this problem. I used at the
> beginning of
> the XSP pages the string:
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
>
> What I am doing wrong?
>
> Regards,
>
> Antonio Gallardo
>
> El Jueves, 29 de Agosto de 2002 01:57, Antonio Gallardo Rivera escribió:
> > I am using PostgreSQL 7.2.1
> > If I store a string value, like "Olé" in the Database without
> using Cocoon.
> > I can get it back. Without any problem. It is stored correctly. But, In
> > Cocoon 2.03 (Tomcat 4.1.9)
> >
> > I need to store values to the Database like "Olé". I saw that the Cocoon
> > manipulate the data like UTF-8 and not in the code ISO-8859-1.
> How I can
> > change this feature to make Cocoon work in ISO-8859-1 code?
> >
> > Regards,
> >
> > Antonio Gallardo
> >
> > ---------------------------------------------------------------------
> > Please check that your question has not already been answered in the
> > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
> >
> > To unsubscribe, e-mail: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@xml.apache.org>
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: How to encode ISO-8859-1 characters into the Database?
Posted by Antonio Gallardo Rivera <ag...@agsoftware.dnsalias.com>.
I create the Database now using the following string:
createdb -E LATIN1 -e mydb
Where,
LATIN1 is the encoding used by the database
mydb is the name of the database
Now When I wrote: "Olé"
When I retrieve the values there are: "Olé"
Please, somebody know how to resolve this problem. I used at the beginning of
the XSP pages the string:
<?xml version="1.0" encoding="ISO-8859-1"?>
What I am doing wrong?
Regards,
Antonio Gallardo
El Jueves, 29 de Agosto de 2002 01:57, Antonio Gallardo Rivera escribió:
> I am using PostgreSQL 7.2.1
> If I store a string value, like "Olé" in the Database without using Cocoon.
> I can get it back. Without any problem. It is stored correctly. But, In
> Cocoon 2.03 (Tomcat 4.1.9)
>
> I need to store values to the Database like "Olé". I saw that the Cocoon
> manipulate the data like UTF-8 and not in the code ISO-8859-1. How I can
> change this feature to make Cocoon work in ISO-8859-1 code?
>
> Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>