View Single Post
  #16  
Old September 14th, 2007, 03:24 PM posted to microsoft.public.access.tablesdbdesign
mscertified
external usenet poster
 
Posts: 835
Default How many MEMO fields allowed in a table?

One thing I have run into a few times is when you do a UNION join between 2
tables that contain a memo column, the memo column gets truncated. There are
ways around this but it can trip you up and may not be detected until the bug
has existed for a long time when someone notices the truncation.


"Michael Gramelspacher" wrote:

Jamie, a single-column key that is 1,000 characters wide seems absurd
in my mind.

NVARCHAR and NCHAR are not recognized by most people as Access
datatypes. And in SQL Server their length can be 4,000 characters
according to Books on Line. An Access Text datatype is limited to 255
characters.

I guess my vision does not extend much beyond the Access world. And I
am still left wondering why I might want to index or sort a memo
column.


On Fri, 14 Sep 2007 08:29:20 -0000, Jamie Collins
wrote:

One reason is the 255 chracter limit on NVARCHAR AND NCHAR columns.

One government agency schema I must work with has a wide key; let's
say it's up to 1000 characters. In Jet, this column would be best IMO
as a MEMO column (yes I know it's blob data but surely that's better
than scaling my own NCHAR/NVARCHR columns?)