mysql 存储unicode_如何使用存储过程在MySQL中插入Unicode数据

I had created one application.used Fronde vs 2010 and backed MySQL 5.3 version.this application i am used store-procedure in MySQL .i am insert data in English it's work.but i am insert Unicode date (like Marathi or Hindi) on same stored-procedure error's is generated. The error is :-"Incorrect string value: '\xE0\xA4\x90 \xE0\xA4...' for column 'p_hindicontent' at row 1"

Pleases help me.

Thank you in Advances

解决方案You need to select UTF8 as teh character set or collation when you create the column:

CREATE TABLE MyTable

(

...

MyColumn CHAR(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci

...

)

you to write the stored procedure like this

DROP PROCEDURE IF EXISTS `cn_marathidata`.`SPemp`

CREATE DEFINER=`root`@`localhost` PROCEDURE `SPemp`(

in P_name text charset utf8,

in P_address text charset utf8

)

BEGIN

INSERT INTO Employee

(

name,

address

)

VALUES

(

P_name,

P_address

);

END