Get first UTF-8 char from string and save in DB

Question

I have a problem with inserting a letter that is not an A-Z char.
For example:

$fullTag = 'świat';

A 'letter' should contains ś

$data = array(
    'full_tag'  => $fullTag,
    'count'     => 1,
    'letter'    => $fullTag[0],
);

But when I execute $table->insert($data);, it inserts me as letter an empty string.

If I set instead of $fullTag[0] a static letter ś - it works fine.

letter column is utf8_polish_ci char(1)

Any ideas ?

Answer 1

instead of $fullTag[0], you may want to use a multibyte substring function: http://www.php.net/manual/en/function.mb-substr.php .. these mb_* functions are aware of multibyte encodings, $fullTag[0] may only give you one byte.