Jump to content

Cut and Paste Apostrophe cause insert error

apostrophe error insert

  • Please log in to reply
1 reply to this topic

#1 Madeleine McJones

Madeleine McJones


  • Members
  • Pip
  • 1 posts

Posted 05 January 2016 - 10: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?



#2 Amit Shah

Amit Shah

    grocery CRUD Master

  • Advanced Member
  • PipPipPip
  • 1,192 posts
  • LocationMumbai, India

Posted 06 January 2016 - 01:59 AM



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 :)

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users