function UberTrim($s) {
    $s = preg_replace('/\xA0/u', ' ', $s);  // strips UTF-8 NBSP: "\xC2\xA0"
    $s = trim($s);
    return $s;
}

The UTF-8 character encoding for non-breaking space, Unicode (U + 00A0), is a 2-byte sequence C2 A0 . I tried using the second parametertrim() , but that did not help. Usage example:

assert("abc" === UberTrim("  \r\n  \xc2\xa0  abc  \t \xc2\xa0   "));

MySQL TRIM(text_field), UTF, @RudolfRein:

TRIM(REPLACE(text_field, '\xc2\xa0', ' '))

UTF-8:

( )

• , PHP UTF-8 . .

• , MySQL UTF-8 ( ),

  $pdo = new PDO('mysql:host=...;dbname=...;charset=utf8',$userid,$password); $pdo->exec("SET CHARACTER SET utf8");

• , HTTP UTF-8, . Apache:

  AddDefaultCharset UTF-8

• , UTF-8.

  header('Content-Type: text/html; charset=utf-8');

  <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />

UTF-8 NBSP, :

REPLACE(the_field, UNHEX('C2A0'), ' ')

"" . - HTML,  , , .

echo urlenclde($row['field']);

,

A0 ( 160 ) , :

<pre><?php
$str = urldecode("%A0")."bla";
var_dump(trim($str));
$str = str_replace(chr(160)," ",$str);
$str = trim($str);
var_dump($str);

, ta-dam! -

string(4) " bla"
string(3) "bla"

, "", charactercode. , . Trim , , , , CR NUL, , .