charset problem... sigh

This is a discussion on charset problem... sigh within the MySQL Database forums, part of the Database Forums category; Hi, i'm sorry to post another question on charset problem but i'm going out crazy I'm working ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 09-12-2007
phabius-fabius@libero.it
 
Posts: n/a
Default charset problem... sigh

Hi, i'm sorry to post another question on charset problem but i'm
going out crazy
I'm working with Mysql 4.1.20, Apache2 and jsp pages.
I've a jsp page that shows query results so no one letter in this page
is written by me. All mysql tables are encoded with latin1 charset and
latin1_swedish_c1 collation. In http.conf i've added
"AddDefaultCharset ISO-8859-1" directive.
But i've no idea why accented words are replaced by a simple "?". I've
added <META HTTP-EQUIV="Content-Type" CONTENT="text/html;
charset=iso-8859-1"> in my jsp pages but nothing at all

And besides if i do a query in mysql all result are exactly showed and
if i write something like this "àèò" in jsp page, in browsers all goes
ok

Thank u all

Reply With Quote
  #2 (permalink)  
Old 09-12-2007
lark
 
Posts: n/a
Default Re: charset problem... sigh

== Quote from phabius-fabius ( phabius-fabius@libero.it)'s article
> Hi, i'm sorry to post another question on charset problem but i'm
> going out crazy
> I'm working with Mysql 4.1.20, Apache2 and jsp pages.
> I've a jsp page that shows query results so no one letter in this page
> is written by me. All mysql tables are encoded with latin1 charset and
> latin1_swedish_c1 collation. In http.conf i've added
> "AddDefaultCharset ISO-8859-1" directive.
> But i've no idea why accented words are replaced by a simple "?". I've
> added <META HTTP-EQUIV="Content-Type" CONTENT="text/html;
> charset=iso-8859-1"> in my jsp pages but nothing at all
> And besides if i do a query in mysql all result are exactly showed and
> if i write something like this "���" in jsp page, in browsers all goes
> ok
> Thank u all



what jsp engine are you using?
--
POST BY: lark with PHP News Reader
Reply With Quote
  #3 (permalink)  
Old 09-13-2007
phabius-fabius@libero.it
 
Posts: n/a
Default Re: charset problem... sigh

On 12 Set, 22:12, lark <ham...@sbcglobal.net> wrote:
> == Quote from phabius-fabius ( phabius-fab...@libero.it)'s article
>
> > Hi, i'm sorry to post another question on charset problem but i'm
> > going out crazy
> > I'm working with Mysql 4.1.20, Apache2 and jsp pages.
> > I've a jsp page that shows query results so no one letter in this page
> > is written by me. All mysql tables are encoded with latin1 charset and
> > latin1_swedish_c1 collation. In http.conf i've added
> > "AddDefaultCharset ISO-8859-1" directive.
> > But i've no idea why accented words are replaced by a simple "?". I've
> > added <META HTTP-EQUIV="Content-Type" CONTENT="text/html;
> > charset=iso-8859-1"> in my jsp pages but nothing at all
> > And besides if i do a query in mysql all result are exactly showed and
> > if i write something like this "???" in jsp page, in browsers all goes
> > ok
> > Thank u all

>
> what jsp engine are you using?
> --
> POST BY: lark with PHP News Reader


i'm using jakarta-tomcat. But i'm sure that problem is into mysql
server because if i write a java program i obtain same results when i
retrieve data from a mysql query

Reply With Quote
  #4 (permalink)  
Old 09-13-2007
phabius-fabius@libero.it
 
Posts: n/a
Default Re: charset problem... sigh

On 13 Set, 08:42, phabius-fab...@libero.it wrote:
> On 12 Set, 22:12, lark <ham...@sbcglobal.net> wrote:
>
>
>
>
>
> > == Quote from phabius-fabius ( phabius-fab...@libero.it)'s article

>
> > > Hi, i'm sorry to post another question on charset problem but i'm
> > > going out crazy
> > > I'm working with Mysql 4.1.20, Apache2 and jsp pages.
> > > I've a jsp page that shows query results so no one letter in this page
> > > is written by me. All mysql tables are encoded with latin1 charset and
> > > latin1_swedish_c1 collation. In http.conf i've added
> > > "AddDefaultCharset ISO-8859-1" directive.
> > > But i've no idea why accented words are replaced by a simple "?". I've
> > > added <META HTTP-EQUIV="Content-Type" CONTENT="text/html;
> > > charset=iso-8859-1"> in my jsp pages but nothing at all
> > > And besides if i do a query in mysql all result are exactly showed and
> > > if i write something like this "???" in jsp page, in browsers all goes
> > > ok
> > > Thank u all

>
> > what jsp engine are you using?
> > --
> > POST BY: lark with PHP News Reader

>
> i'm using jakarta-tomcat. But i'm sure that problem is into mysql
> server because if i write a java program i obtain same results when i
> retrieve data from a mysql query- Nascondi testo tra virgolette -
>
> - Mostra testo tra virgolette -


ah... i've all character_set_% variables set to 'latin1' and all jsp
pages encoded by ISO-8859-1charset

Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:58 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0