How to make a MS Access field 'Allow Zero Length' = true

How to make a MS Access field 'Allow Zero Length' = true from delphi
in CREATE database dunction?
djuzoranAsked:
Who is Participating?
 
Ferruccio AccalaiSenior developer, analyst and customer assistance Commented:
You mean a Text field?
If you do not specify nothing it is intended as it can accept zero length, otherwise it must be declared as Not Null

for example:

create table MyTable(MyField Text(10), //accept zero length
                               MySecondField(19) not null, //value is required
                               MyThirdField Integer);

0
 
djuzoranAuthor Commented:
So
MyField Text(10)

is not the same as

MyField Varchar(10) ?

0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Ferruccio AccalaiSenior developer, analyst and customer assistance Commented:
Yes it's the same, btw forgot mi last comment, it's about required property, not zero length, sorry
0
 
djuzoranAuthor Commented:
So what should i write for nullable and zero length column?

0
 
Ferruccio AccalaiSenior developer, analyst and customer assistance Commented:
Well i was looking at it at all but look at here also http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3BQ217156
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.