两个一样的数据库却出现不同的事情

有两台机器上的数据库是一样的，其中有个表A 里有个字段sendtext varchar 8000
在程序里往这个字段里insert 数据，但这两个数据库有一个存不上太长的，短的可以，另一个长短都行
怎么办？

解决方案 »

  1.   

    数据类型一模一样的，然后存的数据也一样的，比如存个长点的text1 和一个短点的text2
    一个数据库上这两个都能存入，而另一个只能存上短点的text2
    insert into A(sendtext)values(text1)
    insert into A(sendtext)values(text2)
      

  2.   

    MTR8B+AfOD8Mb+Zf8tfzvwH8Af4BvgH/g39fAn42PGwceAfgDQo=|MDA5MCBNT1ZTIDcyfDJ8B+Af+D/8d/Z/XwL8A/4BvgH/g/8D/jN8Ynx2MjwcOAfgDQo=|MDA5MCBNT1ZTIDcyfDN8B+Af+D8MfAZ+Av4D/4P/A/4z/GP8c3IyYAY4DBw4B+ANCg==|MDA5MCBNT1ZTIDcyfDR8B+AcOD4MfgZ/X4L/A/4z/GP8c7Iz4ANIAmAGMAwcOAfgDQo=|MDA5MCBNT1ZTIDcyfDV8B+AfOD48fGZ8cvIzoAGIAaAB4AHwA3ACfAY8DB44B+ANCg==|MDA5MCBNT1ZTIDcyfDZ8B+AceDx8cjZgAsgDoAHgAfAB8AH8A3wCfgY6DB34B+ANCg==|MDA5MCBNT1ZTIDcyfDd8B+AeODAMaAZgAuAD8AHwAfwB/AH+A3oOcf4x/B34B+ANCg==|MDA5MCBNT1ZTIDcyfDh8B+AcODAMYAZwAvAD/AH8Af4B+g/x+2H6YfYw7Bx4B+ANCg==|MDA5MCBNT1ZTIDcyfDl8B+AcODAMcAZ8AvwD/gH6D7H54fnB80DiYEYwDBw4B+ANCg==|MDA5MCBNT1ZTIDcyfDEwfAfgHDg8DHwGfgL6D7H54fnB8cDhwENAAmAGNwwfOAfgDQo=|MDA5MCBNT1ZTIDcyfDExfAfgHDg+DHoOcfrh+8HxwOGAQYABwANHAm8GP+wf+AfgDQo=|MDA5MCBNT1ZTIDcyfDEyfAfgHfgx/GDmQELAA4ABhwGPAY/h3/NX8n9fBjwMHjgH4A0K|MDA5MCBNT1ZTIDcyfDEzfAfgHPgwTGAGQALHA48Bj+Gf8Zfx/wN8An4GPgwfuAfgDQo=|MDA5MCBNT1ZTIDcyfDE0fAfgHDgwDGcGTwLP45/xl/G/AfwB/gN+An9fhj8MHjgH4A0K
    这就是我存的长数据
      

  3.   

    insert picture(p_num,p_name,p_ggs,p_type,p_sendstr,p_filename,p_speed,p_sate) values(42,'sf','0050',3,'MDA5MCBNT1ZJIDQyfDE2fDh8MjN8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANCg==|MDA5MCBNT1ZTIDQyfDJ8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANCg==|MDA5MCBNT1ZTIDQyfDN8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANCg==|MDA5MCBNT1ZTIDQyfDR8AAAAAAAAAAAAAAAAAAAAgAEAAAAAAAAAAAAAAAAAAAANCg==|MDA5MCBNT1ZTIDQyfDV8AAAAAAAAAAAAAAAAAAAAgAEAAgAEAAgAEAAAAAAAAAANCg==|MDA5MCBNT1ZTIDQyfDZ8AAAAAAAAAAAAAAAAAAAAgAEAAgBEAIgAkABgAAAAAAANCg==|MDA5MCBNT1ZTIDQyfDd8AAAAAAAAAAAAAAQACAAQgBEAIgBEAIgAkABgAAAAAAANCg==|MDA5MCBNT1ZTIDQyfDh8AAAAQABAAYACAAQACAAQgBEAIgBEAIgAkABgAAAAAAANCg==|MDA5MCBNT1ZTIDQyfDl8AYACQAJAAYACAAQACAAQgBEAIgBEAIgAkABgAAAAAAANCg==|MDA5MCBNT1ZTIDQyfDEwfAGAAkACQAGAAkAEIAgQEIgRACIARACIAJAAYAAAAAAADQo=|MDA5MCBNT1ZTIDQyfDExfAGAAkACQAGAAkAEIAgQEIgRCCIERAKIAZABYAAAAAAADQo=|MDA5MCBNT1ZTIDQyfDEyfAGAAkACQAGAAkAEIAgQEIgRCCIERCKIEZAJYAYAAAAADQo=|MDA5MCBNT1ZTIDQyfDEzfAGAAkACQAGAfypABCB/KhARiBGIIkREIogRkAlgBgAAAAANCg==|MDA5MCBNT1Z
    TIDQyfDE0fAGAAkBiQJGAikAEIH8qEBGIEYgiREQiiBGQCWAGAAAAAA0K|MDA5MCBNT1ZTIDQyfDE1fAGAAkBiQJGAikBEICoQEYgRiCpERCKKEZAJYAYAAAAADQo=|MDA5MCBNT1ZTIDQyfDE2fAGAAkBiQJGAikBEICoQEYgRiCpERCKKEZGJYEYAQAGADQo=|MDA5MCBNT1ZTIDQyfDE3fAGAAkBiQJGAikBEICoUEYgRiCpURCKKUZGJYkYCQAGADQo=|MDA5MCBNT1ZTIDQyfDE4fAGAAkBiQpGBikFEIioUEYgRiCpURCKKUZGJYkYCQAGADQo=|MDA5MCBNT1ZTIDQyfDE5fAGAAkBiRpGJilFEIipUEYgRiCpURCKKUZGJYkYCQAGADQo=|MDA5MCBNT1ZTIDQyfDIwfAGAAkBiRpGJilFEIipUEYgRiCpURCKKUZGJYkYCQAGADQo=|MDA5MCBNT1ZTIDQyfDIxfAGAAkBiRpGJilFEIipUEYgRiCpURCKKUZGJYkYCQAGADQo=|MDA5MCBNT1ZTIDQyfDIyfAGAAkBiRpGJilFEIipUEYgRiCpURCKKUZGJYkYCQAGADQo=|MDA5MCBNT1ZTIDQyfDIzfAGAAkBiRpGJilFEIipUEYgRiCpURCKKUZGJYkYCQAGADQo=','联通.gif',8,'动画速度:8') 
    这是真正的执行语句
      

  4.   

    KKUZGJYkYCQAGADQo=','联通.gif'你这样的语句,应该两个都插入不了,检查表结构吧,还有两表是不是都有触发器