lists.zerezo.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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 <anandkl@xxxxxxxxx> 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 <yueliangdao0608@xxxxxxxxx> 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: jiang8jianguo@xxxxxxx
>>          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