By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,491 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,491 IT Pros & Developers. It's quick & easy.

Strange Select Distinct Behaviour

P: n/a
I have a table containing different field types including a memo field. If
I do a select distinct on the table the memo field is truncated to 256
characters. I've never encountered this before, is it a known issue?

Thanks.

Keith.
Nov 7 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Keith Wilby" <he**@there.comwrote in message
news:45**********@glkas0286.greenlnk.net...
>I have a table containing different field types including a memo field. If
I do a select distinct on the table the memo field is truncated to 256
characters. I've never encountered this before, is it a known issue?

Thanks.

Keith.
Hmm ... having thought about it, it must be perfectly reasonable behaviour.
You couldn't expect the db engine to compare almost infinite numbers of
characters.
Nov 7 '06 #2

P: n/a
"Keith Wilby" <he**@there.comwrote in
news:45**********@glkas0286.greenlnk.net:
I have a table containing different field types including a
memo field. If I do a select distinct on the table the memo
field is truncated to 256 characters. I've never encountered
this before, is it a known issue?

Thanks.

Keith.
Yes. Access 97 and earlier refused to do select distinct, giving a
warning. It was then possible to edit the query to do a left
(memofield,255) if you needed to include the field in the query.

Since Access 2000, the rules were changed, and Access now simply
truncates the field(s) to 255 characters. Stupid, stupid.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Nov 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.