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

["Ananda Kumar" <anandkl@xxxxxxxxx>]

try to optimize the table and see if the error goes away

On 7/1/08, Moon's Father <yueliangdao0608@xxxxxxxxx> 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 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
>