charset issue during inserting data

Asked Jun 23 '13 at 16:39

Active Oct 24 '16 at 08:21

Viewed 58 times

I have a strange problem, when I'm inserting data into the database.

When I'm passing the value from form field in English, everything works as expected (the value is inserted). However, when I pass the value in another language (e.g. Russian), the value inserts, but it is empty in database table. Not null, just an empty value.

I am using the Kohana framework. I have tried to set the proper charset with mysql_query("SET NAMES utf8");, but it doesn't work, and the table data in the database is set as utf8 and utf8_general_ci.

Anybody knows how to solve this issue?

Hey guys, I just found out that the problem in my Controller, the incoming parameters are in wrong charset. Here is the output result: �� Does anybody know how to set charset in Kohana controller?

edited Oct 24 '16 at 08:21

Avag Sargsyan

2,437
3
28
41

asked Jun 23 '13 at 16:39

Anna Gabrielyan

2,120
3
28
48

``? – Dave Chen Jun 23 '13 at 16:41
yes, – Anna Gabrielyan Jun 23 '13 at 16:47
Could you show some code? At DB-level, what's the charset of your table? – Sylvain Leroux Jun 23 '13 at 19:30
charset in my db set as utf8 and utf8_general_ci – Anna Gabrielyan Jun 23 '13 at 19:33
i just found out that the problem in my Controller, the incoming parameters are in wrong charset : here is the output result �� Anybody knows how to set charset in Kohana controller? – Anna Gabrielyan Jun 23 '13 at 20:09

charset issue during inserting data

0 Answers0