ty bill, Capeesh.
Terence
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Terence
>
> In the world of relational databases there are 2 *basic* types for text: variable characters called varchar and fixed characters called char. Access uses the varchar type.
>
> With the varchar data type, only the actual size of the data is stored with the maximum being the indicated size. A varchar of 50 will store up to 50 characters.
>
> With the char data type, the indicated size is ALWAYS stored even if you don't use it all. So char(50) will always store 50 characters whether you use them or not.
>
> So in Access setting all text fields to 255 (the maximum size) will store the fields or their actual size, not 255.
>
> Capeesh?
>
> I'm ignoring the fact that you can also set the field to unicode compression which would translate to nvarchar in SQL Server. This type stores 2 bytes per character instead of 1 byte in varchar. You would need this for some of the more complex characters such as various types of Japanese script.
>
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "Terence" <buffalome90210@> wrote:
> >
> > As I understand it:
> > Access 2007, the default is that a text field in a table default to 255 characters unless you change the default.
> >
> > That means that as I create a filed in a table and set its size paramet to ..say 50....I do indeed get a size of 50 characters, and thus a disk space saveings ?
> >
> > Terence
> >
>
Tidak ada komentar:
Posting Komentar