a client using Mac's has supplied us with some .txt files, which contain the O tilde, grave and acute characters. 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. I'll try using Asc to find out what they are...
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- Mark Woods <[EMAIL PROTECTED] To: <[EMAIL PROTECTED]> e.ie> cc: Subject: Re: [ cf-dev ] Mac characters 09/07/2003 09:01 Please respond to dev >Anyone got a bit of code that can turn any odd characters that seem to crop >up in text created on the Mac, into their proper equivalents. e.g: >�, �, � all would get changed to an apostrophe. Why should O tilde, O grave and O acute be converted to apostrophes - are you seeing apostrophes in the original document and O tilde, O grave and O acute after saving the contents of the original document in your CF application? How are these characters getting into your application, are the documents being opened on a PC or are the contents being copied from a doc on the mac and pasted into a form on a web page (within a browser window also open on the Mac)? Knowing the decimal number values for the characters you are having problems with will help diagnose the problem. If you are using CFMX, you can use asc(), if you are using an earlier version of CF, just use javascript, the string method charCodeAt() will do the trick. BTW, if you're wondering why I'm blathering on about O tilde, O grave and O acute, then it's possible that our email apps are using different character sets. If this is the case, what characters did you refer to in your original email? 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] -- ** 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]
