Should we HTML-encode special characters before storing them in the database?

by

Don’t HTML-encode your characters before storage. You should store as pure a form of your data as possible. HTML encoding is needed because you are going to display the data on an HTML page, so do the encoding during the processing of the data to create the page. For example, suppose you decide you’re also going to send the data in plain text emails. If you’ve HTML-encoded the data, now the HTML encoding is a barrier that you have to undo.

Choose a canonical form for your data, and store that. UTF-8 is wonderful, and your database supports it (assuming you’ve created all your tables properly). Just store UTF-8.

More Related Contents:

  1. What is character encoding and why should I bother with it
  2. What’s the difference between encoding and charset?
  3. How do I correct the character encoding of a file?
  4. What is the most efficient binary to text encoding?
  5. What is the most common encoding of each language?
  6. Java : How to determine the correct charset encoding of a stream
  7. Using PowerShell to write a file in UTF-8 without the BOM
  8. What is base 64 encoding used for?
  9. Working with UTF-8 encoding in Python source [duplicate]
  10. How to convert Strings to and from UTF8 byte arrays in Java
  11. What is the difference between UTF-8 and Unicode?
  12. How to support UTF-8 encoding in Eclipse
  13. Detect encoding and make everything UTF-8
  14. How to detect the character encoding of a text file?
  15. Base64 Encode String in VBScript
  16. Why does base64 encoding require padding if the input length is not divisible by 3?
  17. Get a list of all the encodings Python can encode to
  18. What is “=C2=A0” in MIME encoded, quoted-printable text?
  19. How to set standard encoding in Visual Studio
  20. ASP.NET Excel export encoding problem
  21. Difference between Url Encode and HTML encode
  22. UTF-8 output from PowerShell
  23. Is there any benefit to adding accept-charset=”UTF-8″ to HTML forms, if the page is already in UTF-8?
  24. Unicode value \uXXXX to Character in Javascript
  25. Difference between double and single quotation marks in fortran?
  26. PHP messing with HTML Charset Encoding
  27. Emoji value range
  28. Swedish characters and UTF-8
  29. Browser displays � instead of ´
  30. Base64 encode with Stream_StringToBinary inserts a newline, breaking the string?

Leave a Comment