CODEWITHSUNDEEP
phppreg-replacespecial-characters
unknown
unknown

Reputation: 31

Special Characters Problem

When I display contents from the database, I get this:

��Some will have a job. Others will want one. They are my people, they are my clients and they are being denied their rights.

This text had been entered by the user via textarea with tinyMCE. How can I replace special characters (using preg_replace()) from the sentence to ' ' except for the characters: <>?

Upvotes: 3

Views: 350

Answers (2)

Dork
Dork

Reputation: 133

As Chuck mentioned above, it is the database problem. Unless you only wish to display non-Unicode, ie Latin characters, then yes, preg_replace is the way to go. You will need to know the character sets well enough to filter out what you don't want.

But if you just want everything to display nicely, ie no garbage characters, then change the corresponding parts of the db to accept utf-8.

e.g. If you are using mySQL, try changing the field and table encoding to be able to accept UTF-8. The default is latin1_general_ci - try changing it to utf8_general_ci. Hope that explains my point.

Upvotes: 0

Chuck Vose
Chuck Vose

Reputation: 4580

This article is totally worth a read. Dealing with UTF-8 characters is something that we all go through at some point. The trick seems to be to catch them before they go into the database or to fix the database so that when they're going in they aren't broken. Once they're in there though it's slightly more difficult.

Upvotes: 1

Related Questions