Member Avatar for mark.giles.14

Should apostrophe's be stored from a form into a database as ’ or as is '

If Im pasting articles into a database from another website do I need to convert the string on posting or leave them as it is.

  • 2 Contributors
  • 4 Replies
  • 141 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by mark.giles.14
Member Avatar for pritaeas

Depends what method you are using. If you are using MySQLi or PDO, then parameter binding will take care of it.

Member Avatar for mark.giles.14

Thanks Im using mysqli.
So if I bind paramaters it will take care of itself ?.

Member Avatar for pritaeas

It's always best to sanitize input anyway, but when using binding the apostrophes aren't an issue.

Member Avatar for mark.giles.14

How would I go about sanitizing ?.
Also a lot of earlier records in my database pre changing mysql to mysqli now show with weird symbols instead of apostrophe's any idea how to rectify that problem as below ?.

O�Shea

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.