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
- 584 views
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