Weird characters showing up in form action page

[oaklandar]

I have a Cold Fusion form that uses a memo field (using a textarea) to populate my Access 2000 database. The form works great but if someone copies from an Internet Browser page into my form memo field it doesnt insert the data into my Access database and gives me a sql error. The sql errors shows the data that is copied from an internet browser and it has weird characters that look like greek characters. Is this a translation problem that can be fixed somehow with JavaScript??

It does this with both my Netscape 7 and IE 6 Browser.

Please advise if there is something I can do to fix this?

 

[dougcranston]

Suggest you apply a filter to strip the non-character "characters" from the textarea.

Depending on what you want or expect to be stored in the Access DB, you need to tailor the "filter" to pass those characters to the DB that you want/need, and remove those others.

Have seen this occur when cutting and pasting from Word or other MS apps. If you look at an ASCII chart there will be a couple of single quotes, of which one will yield a hi-bit/greek character.

One example can be seen at:

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=151

Although this is dealing with a DOUBLE SPACE, you could adapt for your needs.

HTH

Dougc