⚠ 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. ⚠

  •     

profile picture

Cut and Paste Apostrophe cause insert error



Madeleine McJones

Madeleine McJones
  • profile picture
  • 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

Amit Shah
  • profile picture
  • 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 :)