Empty string in sql server where not null

Data Abstract
1

Hello,

I have setup a few test tables in SQL Server.
One of the tables contains a companyname type nvarchar(100) and marked as not null.
If I look in the Schema modeler, the field is also indicated as required.
When I add or modify a record, it accepts an empty dbedit field in Delphi.
When I try to add a record in SQL Server directly it does not allow this.

What am I doing wrong?

Thx,
Bernaert Dominique

2

usually not null indicates that it should have some value. try to fill this field with one space.