What's the access data type for "varchar"

J

John Vinson

On Tue, 19 Apr 2005 14:25:03 -0700, "bmnjugun"

No *exact* equivalent; Text is functionally a 0-255 byte Varchar (you
need to use Memo if you want more characters).

The SQL fixed-length Text field type isn't provided by default in
Access (you can force it with some difficulty). Generally, trailing
blanks are removed from any text field.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VARCHAR datatype 1
Data Type nvarchar or varchar 13
Defining default values for fieds in CREATE TABLE statement? 6
from varchar(8000) to varchar(max) 5
Type Mismatch Error Driving Me Nuts 3
Compare the "varchar" values 2
new table or lots of null values 1
Parameter Type/Size Property Values for VARCHAR(MAX) Stored Proc Parameter 2

Top