General error: 1366 Incorrect string value: '\xE0\xAE\x95\xE0\xAF\x8A...' for column 'occupation' in Laravel

Asked Jun 07 '17 at 10:30

Active Jun 07 '17 at 11:08

Viewed 2,345 times

I am doing Tamil Language based Billing Web Application in Laravel. When I store tamil Unicode Data in database its display following Error.

SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xE0\xAE\x95\xE0\xAF\x8A...' for column 'occupation' at row 1 (SQL: insert into `occupation` (`occupation`, `created_by`, `updated_at`, `created_at`) values (கொத்தனார், 1, 2017-06-07 10:14:58, 2017-06-07 10:14:58))

How to Fix this Issue. I change db config to

'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',

and also defined charset to utf-8 in page Head

edited Jun 07 '17 at 11:08

asked Jun 07 '17 at 10:30

Karthik

5,589
18
46
78

make sure the table collation is utf8 too – Onix Jun 07 '17 at 11:00
@Onix already i set Table Collation to utf8_unicode_ci – Karthik Jun 07 '17 at 11:06
try this https://stackoverflow.com/a/6788223/4668162 i hope it works, – Onix Jun 07 '17 at 11:26
2

@Onix Finally i change occupation data type to blob its inserted. blob data type is good for storing unicode characters – Karthik Jun 07 '17 at 11:40

General error: 1366 Incorrect string value: '\xE0\xAE\x95\xE0\xAF\x8A...' for column 'occupation' in Laravel

0 Answers0