The "table level" is actually a red-herring in this case. It seems to
be relevant to your problem but actually it is not relevant. The "table
level" is simply a number that indicates the minimum version of Paradox
that will know how to open this table based on the features you have
used in it. The level will always be set to the -lowest- possible
number, and it can go up or it can go down as features (like "I" fields,
descending indexes, etc.) are added or removed.
This is much different from, say, Microsoft Access, which uses
table-levels for marketing reasons ;-) and changes the internal
data-format all the time.
Now what *is* important to you, and what's causing your problem, is the
fact that the language-drivers are not the same. They should be; must
be. They *cannot* be mixed in a single table family or you will get
constant "corrupt file" messages.
The problem is that the language-driver determines, among other things,
the sort order. The collating-sequence of characters, and what binary
codes should occur in character data. It applies both to a table and to
all of its indexes. Mismatched language-drivers can cause data to be
"sorted out-of-order" the moment a record is inserted or changed,
causing "corrupt file" messages.
You must use a single language-driver that accommodates all of the
international characters you need to use. You should also declare the
same driver in your BDE Config.
Quote
>LADRILLO wrote:
> My applications are running over BDE 4.51/Delphi 3 with Paradox 4.x, 5.x and
> 7 tables.
> My new users are have all their tables of level 7, but my old ones have a
> mix of 4, 5 and 7,
> and some tables are declared with a different language driver than the
> configured in the BDadmin.
> how can this mix affect the performance and security of my application?
> What are the differences between 4,5 and 7 level in paradox tables?
> When i change the language driver of a table some characters change, how
> can i change the language driver and preserve the same characters?
> I have one user that sometimes gets into the same table the message
> CORRUPT FILE - Other than header
> My application have the tables distributed into a variety of directories,
> how can i convert
> all them into paradox 7 format and change the language driver? it would be
> better?
--------------------------------------------------------------------
Sundial Services :: Scottsdale, AZ (USA) :: (480) 946-8259
mailto:i...@sundialservices.com (PGP public key available.)
Quote
> Why =shouldn't= it be quick and easy to keep your database online?
> ChimneySweep(R): "Click click, it's fixed!" {tm}
> http://www.sundialservices.com/products/chimneysweep
