apostrophes turn into squares

[PhilFromFrance]

Hello, My ISP recently switched to CFMX and a new server. I am using MS
Access and some characteres (apostrophe, dash, euro sign, etc) turn into
squares or other strange signs when inserted into Access. When testing I also
noted that some apostrophes or dashes turn into squares and some do not. When
I look closely there seem to be the wrong type of apostrophe and the right type
(same font). Very strange. Perhaps someone can help me in setting up MS
Access so that it accepts all characteres ? (or help me change my code). Many
thanks in advance Philippe

[vkunirs]

Hi

when inserting the data into the database use the preservesinglequotes in your query.
this preserve all your quotes and saves in the database as it is.
try it out this

[AAOS]

We were having the same problem if a symbol was used for apostrophes and dash.
The solution is to use the Access with unicode support as the driver. It will
not correct existing data but will preserve the symbols with new data. Pam

[JMGibson3]

It sounds like people are Copy/Pasting out of MS-Word. Search on 'smart
quotes' and you will find countless work arounds (replace 'smarts' with
'normals') if you don't want to get into unicode hassles.

[PaulH]

no such thing as a "unicode hassle". it solves char encoding problems, it does not create any.