VARCHAR datatype

[Mike]

Group

I have a piece of software that allows me to use a ODBC service to
authenticate users. I get a invalid user id and password. They are very
specific in the layout of the table as one would expect. Below is the format
of the table that they give.

Name Type
USERID VARCHAR
PASSWORD VARCHAR
FULLNAME VARCHAR
FTPMAXSPACE INTEGER
FTPMAXFILES INTEGER
FTPFLAGS INTEGER

Is the VARCHAR type equivalent to text? If not what is it?

mike (dot) sundman (at) ctd1. ((com))

 

[Michel Walsh]

Hi,


varchar( n ) in MS SQL Server was used to be TEXT(n) in Jet, through
the User Interface, but preferable to use VARCHAR(n) if you define your
table through DDL (Jet 4.0), since it seems that recently, TEXT(n) has
become equivalent to the MS SQL Server char(n) data type ( a fixed string
of n characters, rather than a variable length string of characters). Note
that TEXT in MS SQL Server is MEMO in Jet.


Hoping it may help,
Vanderghast, Access MVP