Share via

char vs varchar in Access

OSVBNET 1,391 Reputation points
2022-08-17T07:01:32.227+00:00

Hello,
The above page mentioned:

char (field size), where field size is less than or equal to 255 - Text - Same as SQL Server field size
vs
varchar (field size), where field size is less than or equal to 255 - Text - Same as SQL Server field size

When inside MS Access 2016 we create a ShortString field, how to set it as char vs varchar (length is less than 255), not documented?

https://support.microsoft.com/en-us/office/comparing-access-and-sql-server-data-types-9188f41d-6c0e-4733-9d20-d08916f50bd2

Microsoft 365 and Office Access Development
Microsoft 365 and Office Install, redeem, activate For business Windows

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.