a client using Mac's has supplied us with some .txt files, which contain the O tilde, grave and acute characters.
So, the text files were created on a Mac, and you see the O tilde etc. when you open the files in Windows? How do you know they should be replaced with apostrophes? Educated guess? When you get the asc() values of the O tilde, grave and acute characters, are they all the same by any chance?
Cutting and pasting the info into an Access db just now, but I'd like to be able to automatically ensure if they are adding text themselves through a form, that any odd characters get amended correctly.
well, adding via a form on a web page makes things easier, because you can set the character set for the document to ISO-8859-1 (not with meta, use cfheader or cfcontent). Can you require IE6 or will these forms be publicly available? As far as I recall, IE6 (maybe IE5.5 too, can't remember) will automatically escape characters outside of the range of the character set for the document to HTML escape sequences (eg. &8235;).
Mark
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
