PHP at CLI with cyrillic content?

Question

I need for a php script support for cyrillic characters.
/etc/php5/cli/PHP.ini:

default_charset = "UTF-8"

My script asks values from a MySQL table (collation: utf8_general_ci) and write those values inside a php variable.

The output of the script is just "???" instead of text, so I guess there is still a problem with a wrong charset, if that MySQL value is a normal latin text, the output of that script is fine.

The website itself works fine with cyrillic letters, only at command line I have these problems.

Do I have to give some additional options at command line?

You should explain better which is the problem with the cli: which console are you using? Is it a problem with input or output? when the problem occours? — Manuel, May 11 '15 at 09:41
Did you also set `mbstring.internal_encoding = UTF-8` in php.ini? — Manuel, May 11 '15 at 09:50
Not before, but the result is the same with `mbstring.internal_encoding = UTF-8` — fips123, May 11 '15 at 09:58
Do you user an UTF-8 locale? try `echo $LANG` in console, also refer to this link https://fruit.je/utf-8 — Manuel, May 11 '15 at 10:13
changed everything to ru_RU.UTF-8 but no difference `echo $LANG ru_RU.UTF-8` — fips123, May 11 '15 at 10:26

score 1 · Accepted Answer · answered May 11 '15 at 11:43

1

The solution is to specify which charset has to be used when sending data from database.
After I add following line to my script, cyrillic characters where shown without problems. mysqli_set_charset($conn, 'utf8');

answered May 11 '15 at 11:43

fips123

261
2
11

PHP at CLI with cyrillic content?

1 Answers1