O.I 3.7

Is there any length limitation in the record keys? The keys are type Varchar.

I’m loosing keys longer than 27 characters, and I need to use keys until 38 chars long.

Thank in advanced

Hector,

38 characters sure sounds like data to me. I recommend you not use data as a key, use a sequential key and index the data to find the record by data…..just my opinion

table=inet_QueryParam(message,"table") ; a tablename </QUOTE> —- === At 01 SEP 2005 11:00AM Dave Harmacek wrote: === <QUOTE>Original specs for LH were for keys up to 50 characters long. I've found that keys with length beyond that can work fine. I suggest you substitute some character (like an underscore) for any space in the key since most ARev commands parse on a space. Dave </QUOTE> —- === At 02 SEP 2005 01:05PM Richard Hunt wrote: === <QUOTE>I believe that linear hash specs would allow for unlimited id lengths. Although Revelation did have a 64k maximum variable length and a 256 maximum literal string character length (and so does OI 16 bit). It is reasonable to believe that an id length greater than 50 characters would be a bit excessive and probably would not be optimal for performance. It is also possible that some routines other than the "linear hash file structure" might not be able to handle it. Using OI version 7.1.1 editor, it will open a row with a 50 character key length, and it will fail to open a row with a 75 character key length. Although the table can handle a "write" command with a key length of 1100 characters, and the "verify linear hash tables" routine verifies the table to be "ok". </QUOTE> View this thread on the forum...