VARCHAR datatype

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 30 Aug 2004 17:48 GMT

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))

Reply to this Message

Michel Walsh - 30 Aug 2004 20:11 GMT

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

> Group
>
[quoted text clipped - 15 lines]
>
> mike (dot) sundman (at) ctd1. ((com))

Reply to this Message