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 PROTECTED]> wrote: > 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] /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 >> *************************** 1. row *************************** >> id: 399502 >> name: ?????? >> email: [EMAIL PROTECTED] >> password: 9e0fe63bb59388909d31e85d2b111216 >> >> Our front language is .net(C#) and the database is MySQL 5.0.45. >> >> Any help is appreciated. >> >> >> -- >> I'm a MySQL DBA in china. >> More about me just visit here: >> http://yueliangdao0608.cublog.cn >> > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
