View Single Post
  #14  
Old September 14th, 2007, 09:33 AM posted to microsoft.public.access.tablesdbdesign
Jamie Collins
external usenet poster
 
Posts: 1,705
Default How many MEMO fields allowed in a table?

On 13 Sep, 23:30, John W. Vinson
wrote:
memos have disadvantages... sorting will
truncate them to 255 bytes


Picky, I know, but yours is a misstatement. To test:

CREATE TABLE Test
(
memo_col MEMO NOT NULL
)
;
INSERT INTO Test (memo_col) VALUES
('123456789012345678901234567890123456789012345678 90123456789012345678901234567890123456789012345678 90123456789012345678901234567890123456789012345678 90123456789012345678901234567890123456789012345678 90123456789012345678901234567890123456789012345678 90123456789012345678901234567890123456789012345678 90_JohnV')
;
INSERT INTO Test (memo_col) VALUES
('123456789012345678901234567890123456789012345678 90123456789012345678901234567890123456789012345678 90123456789012345678901234567890123456789012345678 90123456789012345678901234567890123456789012345678 90123456789012345678901234567890123456789012345678 90123456789012345678901234567890123456789012345678 90_Jamie')
;
SELECT memo_col AS result1, LEN(result1) AS result1_bytes
FROM Test
ORDER BY memo_col
;

result1_bytes returns 306 for both rows. Conclusion: sorting has not
caused truncation.

Jamie.

--