Hi there,
I've been searching for about 6 hours to get a problem solved.
I installed MySQL 4.1.7 on the Debian web-server.
Normally this worked:
insert into logbook (userid,count,dof,aircrid,typeaircr,departure,dest ination,deptime,arrtime,remarks,nrto,nrldg,seland, meland,class1,class2,night,actinstr,siminstr,flins tr,crss,asflinstr,dual,pic,totdur)
VALUES ('1082213471','582','2004-11-22','PHUSJ','DV20','EHAM','EHAM','10:00','11:35',' TEST','1','1','00:45','','','','','','','','00:45' ,'','','00:45','00:45');
Now, I get an error. And I think I know where the problem is. It has
something to do with the charsets and collation.
I surfed on the internet for hours, but could not find how I could
solve this error 1064:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'dual,pic,totdur) VALUES
('1082213471','582','2004-11-22','PHUSJ','DV20','EHAM','' at line 1
The collation in the tabel is set to latin1_swedish_ci.
The characterset is set to utf8.
When I change that (using phpmyadmin) to latin1, it still stays on
utf8.
I changed collation in the table of every row to utf8_general_ci, but
that did not work, too.
PLEASE HELP. I do not know anything I must do.
Greetings,
Temba