Thanks for the help. That may be the case when upsizing, but this
database wasn't. Actually, I found the answer elsewhere - it's because
I was using older ODBC drivers that aren't MS SQL 7 aware. In SQL 6.5
varchar fields have a limit of 255 characters, while in SQL 7 the limit
is 8000.
Jim
-----Original Message-----
From: stas <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Sunday, September 17, 2000 6:06 PM
Subject: RE: MS SQL 7 Varchar
>I believe this happens when you upsize from Access and the original
Access
>field is Text (255).
>
>-----Original Message-----
>From: Jim McAtee [mailto:[EMAIL PROTECTED]]
>Sent: Friday, September 15, 2000 10:19 AM
>To: [EMAIL PROTECTED]
>Subject: MS SQL 7 Varchar
>
>
>I've got a MS SQL 7 table with some fields defined as Varchar(510).
>When I retrieve them in CF Pro 4.01 via ODBC, they get truncated to 255
>characters. Is there a reason for this? How about a workaround?
>
>Jim
>
>-----------------------------------------------------------------------
-----
>--
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
>send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
>the body.
>
>-----------------------------------------------------------------------
-----
>--
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
>send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
>the body.
>
>-----------------------------------------------------------------------
-------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
