substr on UTF-8 strings returned from MySQL

[peter]

I am trying to truncate some Chinese Text returned from MySQL. If I use the
substr function, then the last one or two chinese words would appear as
symbols as opposed to the word it should be displaying? The PHP page itself
is already UTF-8 encoded

What is the best way of truncating such UTF-8 strings (e.g., to return the
first 50 chinese "words"). Chinese words appears like
"?????????????????????" (21 chinese "words" shown here).

[Daniel Tryba]

peter <pe***@mail.co.uk> wrote:

I am trying to truncate some Chinese Text returned from MySQL. If I use the
substr function, then the last one or two chinese words would appear as
symbols as opposed to the word it should be displaying? The PHP page itself
is already UTF-8 encoded
Behold: http://nl2.php.net/manual/en/ref.mbstring.php

The multibyte string functions
What is the best way of truncating such UTF-8 strings (e.g., to return the
first 50 chinese "words"). Chinese words appears like
"?????????????????????" (21 chinese "words" shown here).

mb_substr will do the trick....

--

Daniel Tryba

[Chung Leong]

"Daniel Tryba" <ne****************@canopus.nl> wrote in message
news:ce**********@news.tue.nl...

peter <pe***@mail.co.uk> wrote:

I am trying to truncate some Chinese Text returned from MySQL. If I use the substr function, then the last one or two chinese words would appear as
symbols as opposed to the word it should be displaying? The PHP page itself is already UTF-8 encoded

Behold: http://nl2.php.net/manual/en/ref.mbstring.php

The multibyte string functions

What is the best way of truncating such UTF-8 strings (e.g., to return the first 50 chinese "words"). Chinese words appears like
"?????????????????????" (21 chinese "words" shown here).

mb_substr will do the trick....

--

Daniel Tryba

The PCRE engine of newer version of PHP is also capable of dealing with
UTF-8 text. preg_match('/(.{1,50})/u', $s, $m) would yield a string of 50
characters.