PHP代码调整求助：保留字符串中的Ã、Ê、Ç等特殊字符

Hey there! I see the issue with your current preg_replace code—it's stripping out those accented characters like Ã, Ê, Ç because they aren't included in the basic a-zA-Z character range. Let's adjust this to keep those characters intact, with two solid options depending on your needs:

Option 1: Allow All Unicode Letters (Most Flexible) #

This approach uses a Unicode property class to match any letter from any language (including accented Latin characters), which is the most scalable solution if you might encounter other accented characters later. Just add \p{L} to your allowed character set and include the u modifier (critical for proper Unicode support in PHP regex):

$cleanedName = preg_replace('/[^,\p{L}0-9\.\-\s]/u', "", $row["name"]);

Quick Breakdown: #

• \p{L}: Matches any Unicode letter (covers Ã, Ê, Ç, and all other accented or non-Latin letters you might need)
• u modifier: Tells PHP's regex engine to treat the string as UTF-8, so it properly recognizes Unicode characters instead of processing them as individual bytes

Option 2: Allow Specific Accented Characters #

If you only want to retain exactly the characters you mentioned (Ã, Ê, Ç) and no others, you can explicitly add them to your allowed character set:

$cleanedName = preg_replace('/[^,a-zA-Z0-9\.\-\sÃÊÇ]/', "", $row["name"]);

Heads Up: #

This is less flexible—you'll have to add any new accented characters manually if they come up later, so Option 1 is usually the better long-term choice.

One quick side check: Make sure your PHP file is saved in UTF-8 encoding, and your database connection is set to UTF-8 too. Mismatched encodings can cause unexpected character handling even with the right regex.

内容的提问来源于stack exchange，提问作者Dimitri Putin