CF 9, iText PDF creation, MySQL database: Apostrophe disappears in output PDF

Forum|Forum|14 years ago
January 31, 2011
1 reply
5966 views

I create PDF files using iText. I insert variable data from a MySQL database into form fields (in an existing PDF file). I have an entry in the database "O'Malley" and (only on the output PDF file) the apostrophy is dropped, resulting in "OMalley". The name displays correctly in the database and in online cfm pages. All other special characters that I have tried display correctly in the PDF files as well as online pages. Any assistance would be appreciated.

This topic has been closed for replies.

-

-__cfSearching__-

Inspiring

Can you post a small (stand-alone) example that reproduces the problem?

L

LenderDesignAuthor

Known Participant

Are you requesting a URL or the code that is used to create the PDF file?

L

LenderDesignAuthor

Known Participant

So, I have isolated it to the PDF form fields and/or file.

When I use the datasheet.pdf file, the apostrophe shows. So, I copied the "title" form field from the datasheet.pdf and pasted it into my PDF, and the apostrophe disappears. Then, I copied and pasted the "name" form field out of my PDF document into the datasheet.pdf file and in my form field the apostrophe is absent, but in the "title" form field, the apostrophe shows.

So, that leads me to believe it is the form field that is the issue. I have checked the settings for both form fields and they look to be the same. I checked the version of the PDF files, both are version 1.6 (Acrobat 7.x). I'm at a loss, unless the forms I create with Acrobat version 7.1.0 are somehow the root of the problem.

I'm going to try updating to Acrobat 7.1.4 and see what happens.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded