Q: Sybase, error when creating tables and create the admin user during setup:
The column default_project in table person does not allow null values.
A: With Sybase, by default, it may not allow null values in string columns
(like VARCHAR, TEXT, etc). In that case, you will have the above error. The
solution is to change the database option "allow nulls by default" from false to true.
With Interactive SQL (isql), run
sp_dboption db_name, "allow nulls by default", true
Here, "db_name" is your database name, such as bugzero_db.
* Reference brought to you by
Bugzero, it's more than just bug tracking software!
|
Home -
FAQs
|
|