Take this example query:
SELECT *
FROM table
WHERE colA = 'B1234567xxxx'
in Foxpro table, the colA is set to CHAR(8) and 'B1234567' exists
In MSFT ODBC driver this will return the record, but in Hxtt driver it seems to ignore anything after the 8 char and will also return the record.
Is this supposed to happen? (i.e. feature or a bug?)
|
>Is this supposed to happen? (i.e. feature or a bug?)
A feature simulated Foxpro CDX index, but discarded according to SQL standard .
|
Ah, thank you. Our experience is in SQL, so there is a bit of a learning curve in trying to bridge these 2 eras of db design! We shall handle this difference at the model validation level then.
|