Loading

Problem While Inserting Unicode data In MySQL Stored Procedu

Vikramraj Patil

Respected Sir,

i have created one application. used frond -end VS2010 and backend. MYSQl 5.3 i had create stored-procedure.i had insert English data.it's work but i am insert(unicode data like(marathi,Hindi))on same forms the error's is generated.

"Incorrect string value: '\xE0\xA4\x90 \xE0\xA4...' for column 'p_hindicontent' at row 1" .Pleases help me.

Thank you in advances.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Akhil Garg11y ago
Accepted answer
Instead of giving column as varchar give it as nvarchar in SQL Server and in MY Sql there are different collation https://dev.mysql.com/doc/refman/5.5/en/charset-charsets.html