Re: long text insert failure

2005-08-11 Thread Elizabeth Bonifacio
Thanks a lot guys. I tried my insert using MYSQL Query Browser and manage to insert the syslog. Remo, you're correct, the Windows Command prompt limitation is the cause since i'm using windows xp cmd.exe. I'll try to do import as you've suggested. What a relief, i can proceed in building my syslog

Re: long text insert failure

2005-08-10 Thread Remo Tex
Liz you didn't mention by I suppose you're using Windows client too i.e. mysql.exe. A quick test revealed that in such a case char limit is <=255 i.e. that's limitation of Windows Command Prompt: command.com or in case of Win NT,2000,XP - cmd.exe try writing your long SQL command in text file a