Maximum Datafield Length (OpenInsight 32-bit Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 04 MAR 2003 09:20:17PM Chris Callaghan wrote:

OpenInsight 32-bit Specific

Is there is a maximum field length in OI32?

I'm just wondering because we have VARCHAR(65531) in all our dictionaries, but everything seems fine when I shove a lot more data than 64k into a field.

Does the LH filesystem take any notice of the dictionary datatype or is it just there for the SQL processor and ODBC driver?

At 05 MAR 2003 12:05PM [email protected] wrote:

I'm sure I will be corrected if wrong but ..

No the service doesn't care what data goes in there. It would be nice to have the option but right now .. no

This is the same throughout OI. The only 'field' limitation is what the controls can handle .. but you can write a really big field to the db if you want.

[email protected] onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Phone: 971-570-2005

OS: Win2k sp2 (5.00.2195)

OI: 4.1.2

View this thread on the forum...