MySQL ODBC Connector - not null in MYSQL 5.0

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

not null in MYSQL 5.0

giloosh

2006-01-31, 8:23 pm

has anything changed with a field that is null in mysql 5.0
ie:
FIELD1 CHAR(30) NOT NULL,

i have a program that connects to mysql with myodbc (latest version)
and it worked fine while under mysql 4.1.
after upgrading the database to mysql 5.0 and importing the mysql 4.1
database into the mysql 5.0 database, i starting having trouble
inserting null values into the tables.
i didnt have this problem while using MYSQL 4.1
when i do an insert statement, while leaving out atleast 1field value,
mysql takes it as a null and returns an error.
must i redesign the database to accept NULLs? Must i redesign my
application to work with mysql 5.0?
Thanks for any help.

Sponsored Links