You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Information Architecture <in...@integraonline.com> on 2005/11/15 16:10:48 UTC
Another issue with a special character
Hi! I've been following the posts on special characters and have a
similar problem. I hope this is an appropriate list to post it to. I am
not a java programmer, but support a vertical market application written
in java for which I do not have source and for which the vendor is
unhelpful at best. The program uses a special character, the copyright
sign, to delimit tuples within a single field and parses the field using
the copyright sign when it extracts the data. I have the app working
under Windows 2000 and under SuSE Linux 8.2 running on a P5 system. I
am trying to move the app to SuSE SLES 9 running on a dual processor
opteron. Everything works except the parts that rely on this special
character -- the character is inserted into the database correctly, but
when the field is extracted and parsed, it does not work (it uses the
fields within the delimiters to mark boxes to check). I have tried
inserting the copyright character into a field displayed as text by the
app and it appears on the SLES system as a ?, but on the Windows and
older Linux correctly.
The platform is mysql 4.0, tomcat 4.0 (I tried 5.0 on the new system but
backed down to a version I knew worked on the other system when I
encountered this problem), apache 1.3x (again, started with 2.0 and
moved back to see if the problem exists with the exact same setup).
Java is 1.4.1 on the old system, 1.4.2 on the new system (Sun Client Hot
Spot). As far as I can see, character set is ISO 8859-1 throughout; it
definitely is in mysql. I have tried exporting
"-Dfile-encoding='ISO-8859-1'" in the catalina.sh file but to no avail.
Any suggestions or ideas of where to look would be appreciated.
Thanks.
Becky
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Another issue with a special character
Posted by "Seak, Teng-Fong" <se...@yahoo.com>.
Oh yeah, upgrading softwares helps in a lot of situations. I should
have thought of it and advised it first. Glad that you've figured it
out yourself.
FYI, Java has reached 1.5.0_05, so better upgrade it too.
Information Architecture wrote:
> Teng-Fong,
>
> I appreciated your suggestion about the mysql query browser. I had
> already tried a number of things to verify an 8859-1 char set but
> tried this as well and it was indeed 1 byte. I did, however, finally
> resolve the issue by upgrading the mysql connector J -- the app
> spec'd it at being run with 2.0.14.jar and I tried that plus
> 3.0.12.jar and it didn't work under SLES 9, although it does work with
> the 2.x version under SuSE 8.2. I finally tried 3.1.11.jar from the
> mysql website and things worked from the getgo. The java versions
> themselves aren't very different (1.4.2 as opposed to 1.4.1) but the
> connector made the difference.
>
> Thank you for your assistance.
>
> Becky
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Another issue with a special character
Posted by Information Architecture <in...@integraonline.com>.
Teng-Fong,
I appreciated your suggestion about the mysql query browser. I had
already tried a number of things to verify an 8859-1 char set but tried
this as well and it was indeed 1 byte. I did, however, finally resolve
the issue by upgrading the mysql connector J -- the app spec'd it at
being run with 2.0.14.jar and I tried that plus 3.0.12.jar and it
didn't work under SLES 9, although it does work with the 2.x version
under SuSE 8.2. I finally tried 3.1.11.jar from the mysql website and
things worked from the getgo. The java versions themselves aren't very
different (1.4.2 as opposed to 1.4.1) but the connector made the difference.
Thank you for your assistance.
Becky
Seak, Teng-Fong wrote:
> This seems to be off-topic, but let's continue
>
> Have you used MySQL Query Browser? Try to insert the sign and see
> how many bytes it's using. If it's two, it's almost certainly using
> UTF-8. If it's one, it seems to be OK. Then you have to figure out
> which part in your webapp is changing the character.
>
> Information Architecture wrote:
>
>> Hi! I've been following the posts on special characters and have a
>> similar problem. I hope this is an appropriate list to post it to. I
>> am not a java programmer, but support a vertical market application
>> written in java for which I do not have source and for which the
>> vendor is unhelpful at best. The program uses a special character,
>> the copyright sign, to delimit tuples within a single field and
>> parses the field using the copyright sign when it extracts the data.
>> I have the app working under Windows 2000 and under SuSE Linux 8.2
>> running on a P5 system. I am trying to move the app to SuSE SLES 9
>> running on a dual processor opteron. Everything works except the
>> parts that rely on this special character -- the character is
>> inserted into the database correctly, but when the field is extracted
>> and parsed, it does not work (it uses the fields within the
>> delimiters to mark boxes to check). I have tried inserting the
>> copyright character into a field displayed as text by the app and it
>> appears on the SLES system as a ?, but on the Windows and older Linux
>> correctly.
>> The platform is mysql 4.0, tomcat 4.0 (I tried 5.0 on the new system
>> but backed down to a version I knew worked on the other system when I
>> encountered this problem), apache 1.3x (again, started with 2.0 and
>> moved back to see if the problem exists with the exact same setup).
>> Java is 1.4.1 on the old system, 1.4.2 on the new system (Sun Client
>> Hot Spot). As far as I can see, character set is ISO 8859-1
>> throughout; it definitely is in mysql. I have tried exporting
>> "-Dfile-encoding='ISO-8859-1'" in the catalina.sh file but to no
>> avail. Any suggestions or ideas of where to look would be appreciated.
>>
>> Thanks.
>>
>> Becky
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Another issue with a special character
Posted by "Seak, Teng-Fong" <se...@yahoo.com>.
This seems to be off-topic, but let's continue
Have you used MySQL Query Browser? Try to insert the sign and see
how many bytes it's using. If it's two, it's almost certainly using
UTF-8. If it's one, it seems to be OK. Then you have to figure out
which part in your webapp is changing the character.
Information Architecture wrote:
> Hi! I've been following the posts on special characters and have a
> similar problem. I hope this is an appropriate list to post it to. I
> am not a java programmer, but support a vertical market application
> written in java for which I do not have source and for which the
> vendor is unhelpful at best. The program uses a special character,
> the copyright sign, to delimit tuples within a single field and parses
> the field using the copyright sign when it extracts the data. I have
> the app working under Windows 2000 and under SuSE Linux 8.2 running on
> a P5 system. I am trying to move the app to SuSE SLES 9 running on a
> dual processor opteron. Everything works except the parts that rely
> on this special character -- the character is inserted into the
> database correctly, but when the field is extracted and parsed, it
> does not work (it uses the fields within the delimiters to mark boxes
> to check). I have tried inserting the copyright character into a
> field displayed as text by the app and it appears on the SLES system
> as a ?, but on the Windows and older Linux correctly.
> The platform is mysql 4.0, tomcat 4.0 (I tried 5.0 on the new system
> but backed down to a version I knew worked on the other system when I
> encountered this problem), apache 1.3x (again, started with 2.0 and
> moved back to see if the problem exists with the exact same setup).
> Java is 1.4.1 on the old system, 1.4.2 on the new system (Sun Client
> Hot Spot). As far as I can see, character set is ISO 8859-1
> throughout; it definitely is in mysql. I have tried exporting
> "-Dfile-encoding='ISO-8859-1'" in the catalina.sh file but to no
> avail. Any suggestions or ideas of where to look would be appreciated.
>
> Thanks.
>
> Becky
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org