Why are quotation marks being converted into question marks?


In TRIRIGA Data Integrator, during the loading of data, we’re seeing double quotation marks and extended hyphens being converted to upside-down question marks. This is occurring on a 10.5/3.5 TRIRIGA environment. I’ve verified that the database character set is WE9MSWIN1252. Character Length Semantic = BYTE.

Yes, smart quotes and the long hyphens have been tripping up web applications (not just TRIRIGA, but most others around the web) since they were introduced years ago. Here’s how to disable smart quotes in Microsoft Office (Word/Excel): Click the File tab in the upper left corner of the screen. Select Options. Select Proofing in the left pane. Click AutoCorrect Options. Select the AutoFormat tab. Uncheck “Straight quotes with smart quotes.” Click OK. Do the same thing for the hyphen.

Continue reading

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s