⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Cut and Paste Apostrophe cause insert error

Started by Madeleine McJones, 05 January 2016 - 22:32 PM

Single Page

Madeleine McJones

Member

Posted 05 January 2016 - 22:32 PM

My users are constantly cutting and pasting into the insert screen - they get insert errors on some chars like apostrophes.

Is there a way to parse or disallow these chars and make them type them?

If they get rid of the cut and pasted chars and type it the insert is fine.

The field is VARCHAR?

Thanks!

Amit Shah

Member

Posted 06 January 2016 - 01:59 AM

Hi,

there seems to be ways to deal with the same. 1 - use javascript to deal with. 2, use codeigniter validation rules to deal with the same, or 3 - use callback_before_insert / update to check / clean / take necessary action for the same.

Happy GCing :)