1. Re: ODBC.e : Char Type Column in a Cursor with length 50
- Posted by Michael J. Sabal <m_sabal at y?hoo.com>
Jul 09, 2007
-
Last edited Jul 10, 2007
Matt Lewis wrote:
>
> Rad wrote:
> >
snip...
> > Are there any restrictions on length of character column of cursor in
> > odbc.e?
> > How to get the entire available value of char column with length greater
> > than
> > 50 from a cursor?
>
> Erm. Yeah, apparently it's my fault.
snip...
Not entirely your fault, Matt. Some implementations of SQL (MS SQL Server 7,
for example) have a 50-character limit for char columns. Longer than that,
the column must be defined as varchar or text (memo). I think most current
versions of SQL are more forgiving of this limitation.
Mike Sabal
