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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]






---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to