I upgraded from mysql3 to mysql 4.1 and I just noticed that it won't take queries that are longer than 255 charectors!!!!

When I try to execute this query - it cannot!!!

INSERT INTO MAIN (PER_ID, DATE, AIR_ID, MODEL_ID, DEP, ROUTE, DEST, X_CONTRY, XC135, DAY, NIGHT, IMC, SIM_INST, APP_NUM, NAPP_NUM, HOLDS, DAY_LAND, NIGHT_LAND, DUAL, DUAL_GIV, TYPE, NOTES) VALUES ('guest', '2005-10-18','FDSFSDFSDFSD', '203', '', '', '', '', '', '','','','','', '', '', '1','', '', '', 'PIC', '')


When I try to copy and paste it into the mysql command line it only lets me paste the first 255 charectors. I can't even manually add more!!!!

mysql> INSERT INTO MAIN (PER_ID, DATE, AIR_ID, MODEL_ID, DEP, ROUTE, DEST, X_CON
TRY, XC135, DAY, NIGHT, IMC, SIM_INST, APP_NUM, NAPP_NUM, HOLDS, DAY_LAND, NIGHT
_LAND, DUAL, DUAL_GIV, TYPE, NOTES) VALUES ('guest', '2005-10-18','FDSFSDFSDFSD'
, '203', '', '', '',

What's going on?

I found out what was happening, and I fixed it and I thought I'd explain it incase someone runs into a simular problem.

the 255 charecters was my goof. It wasn't the problem...
This query worked fine for me in mysqld 3.2:

INSERT INTO MAIN (PER_ID, DATE, AIR_ID, MODEL_ID, DEP, ROUTE, DEST, X_CONTRY, XC135, DAY, NIGHT, IMC, SIM_INST, APP_NUM, NAPP_NUM, HOLDS, DAY_LAND, NIGHT_LAND, DUAL, DUAL_GIV, TYPE, NOTES) VALUES ('guest', '2005-10-18','FDSFSDFSDFSD', '203', '', '', '', '', '', '','','','','', '', '', '1','', '', '', 'PIC', '')

Now in Mysql 4.1 it errors.

The reason, the tilda signs need to be there appeanatly and mysql 4.1 appears to be much more sensetive...

INSERT INTO `main` (`PER_ID`, `DATE` ...... etc.........

Can anyone explain why it's working now with the tilda signs? Is it more propper sql sintax????