After successfully installing mdbtools 0.6pre1, I tested things by running some queries on a table that has 14 rows of data in it.
However, mdb-sql returns the 14 rows, but with nothing (NULL) in them.
See:
1 => select * from Cash_Rates
2 => go
+-------+--------------------+----------+----------+----------+--------+--------------------+
|G_Code |E_Date |DailyRate |MvgAvg7 |AvgMat |Modified|ModDate |
+-------+--------------------+----------+----------+----------+--------+--------------------+
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
| | | | | |0 | |
+-------+--------------------+----------+----------+----------+--------+--------------------+
14 Rows retrieved
The same happens with mdb-export:
root@jaguar# mdb-export ***.mdb Cash_Rates
G_Code,E_Date,DailyRate,MvgAvg7,AvgMat,Modified,ModDate
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
,"",,,,0,""
All data is being returned as NULL, even though the correct number of rows are being reported.
Result of mdb-ver:
root@jaguar# mdb-ver ***.mdb
JET4
Here's the schema of that table:
DROP TABLE Cash_Rates;
CREATE TABLE Cash_Rates
(
G_Code Long Integer,
E_Date DateTime (Short),
DailyRate Double,
MvgAvg7 Double,
AvgMat Double,
Modified Boolean,
ModDate DateTime (Short)
);
System:
root@jaguar# uname -srm
FreeBSD 6.1-RELEASE-p7 i386
Logged In: YES
user_id=1669094
Originator: NO
I receive exactly the same weird behaviour, also under FreeBSD 6.1-RELEASE. Only happens with Access 97 files.. if I convert them to Access 2000 or above the problem dissapears.
Also the columns are listed in the wrong order every time... again this is limited to 97.. 2000 and above work correctly..
Logged In: YES
user_id=11673
Originator: NO
Can I get a copy of a database that does this? You can send it directly to me. Reference bug #1602076 in the subject.
Hey
Sorry to popup this bug, but it's still exists.
It happends with the next unicode (utf-8) data:
צמיחת התנועה הלאומית הערבית-הפלסטינאית 1929-1918
It output NULL instead the data. Maybe it happends because of the hyphen, but I'm not sure about that.
OK. After some eximnation I think I got it.
If column data contain two hypens it will return NULL.
Hope that the developers would pay attention for this bug.
I don't know on other cases that it return NULL instead of some data.