Anybody can tell me why our data couldn't be saved incorrect character set in the database?

2008-06-30 Thread Moon's Father
When the memory can not load our application,the error occurs. 080630 17:32:38 [ERROR] /usr/local/mysql/bin/mysqld: Out of memory (Needed 1651540 bytes) And there are some data displayed ? in my database. For example. mysql select * from passport where name like '%??%' limit 1\G

Re: Anybody can tell me why our data couldn't be saved incorrect character set in the database?

2008-06-30 Thread Ananda Kumar
Is this data comming from application or loaded using LOAD DATA command. Can u please check the character set of the db and columns. On 6/30/08, Moon's Father [EMAIL PROTECTED] wrote: When the memory can not load our application,the error occurs. 080630 17:32:38 [ERROR]

Re: Anybody can tell me why our data couldn't be saved incorrect character set in the database?

2008-06-30 Thread Moon's Father
Yeah,they came from .net application and not using load data infile statement. The character set of my db and columns is both utf8; Some wield thing is that the data is normal yesterday ,but they displayed today after the error happened. On Mon, Jun 30, 2008 at 7:01 PM, Ananda Kumar [EMAIL

Re: Anybody can tell me why our data couldn't be saved incorrect character set in the database?

2008-06-30 Thread Ananda Kumar
try to optimize the table and see if the error goes away On 7/1/08, Moon's Father [EMAIL PROTECTED] wrote: Yeah,they came from .net application and not using load data infile statement. The character set of my db and columns is both utf8; Some wield thing is that the data is normal