What's the access data type for "varchar"

  • Thread starter Thread starter Guest
  • Start date Start date
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]
 
In Jet 4.x, John, wouldn't that be 'a 0-255 character NVarChar' ?
 
You must log in or register to reply here.

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
Defining default values for fieds in CREATE TABLE statement? 6
Data Type nvarchar or varchar 13
from varchar(8000) to varchar(max) 5
Parameter Type/Size Property Values for VARCHAR(MAX) Stored Proc Parameter 2
Compare the "varchar" values 2
Type Mismatch Error Driving Me Nuts 3
varchar(1200) sep by ; 6

Back
Top