javamail + mysql = wrong insertion of an apostrophe

[Rodrigo Bossini]

Hi,

I'm using javamail API to download emails from an email inbox. ONce downloaded, my app inserts the message field from the email to a table in mysql.

This message is a simple text. There are no email signatures nor attachements. The message is inserted completely to the table, but it also inserts an apostrophe with the message.

Has anyone seen this problem before? What could possibly cause such a problem?

[Matt Cartwright]

is this around the add-spec address (e.g. [e-mail])?
or around the recipients name (e.g. Matt Cartwright)?

If it's the latter case, you might be using non-atom (RFC2822) characters
in your recipient's name.

If it is addr-spec, your are talking to some legacy SMTP implementation.

All doesn't sound like a Java problem, rather SMTP.

Would you have some code you can post?

Together with its output?

[David Newton]

Matt Cartwright wrote:Together with it'sits output?

[Matt Cartwright]

point taken

[Rodrigo Bossini]

Thanks for replying.

I verified the problem more deeply.

Actually, my application was inserting a double quotes (instead of an apostrophe) mistakenly in the destinatary field (instead of in the message field).

And I found out what the problem was.

Say you are using outlook to send emails, and you add your usual emails as contacts.

When you send a new email to that contact, the destinatary field is formatted like the following:

"[e-mail]" <[e-mail]>

There is the problem. My application was prepared to dealing with <[e-mail]> but not with "[e-mail]".

Thank you all.