|Problems? Is your data what you think it is?|
Re^4: What is your favourite Linux or cross-platform database?by Steve_BZ (Chaplain)
|on Mar 26, 2010 at 13:01 UTC||Need Help??|
Well apart from the install which proved a nightmare under Kubuntu 9.04, but mysteriously cleared up under 9.10 see Installing DBD::ODBC, in the end I gave up using ODBC for the Firebird 2.1 connection because I couldn't get the DATE (and I think also number formats) to work and there were a number of other stability issues which I can't remember. Instead I used the DBI::Interbase driver, while it works, it is subject to occasional crashes, so I'd like to go back to trying ODBC, if it turned out to be more stable.
My current main ODBC problem is that if I use isql on employee.fbd, (eg select first 1 change_date from salary_history), I get:
1992-12-15 00:00:00. (Data type TIMESTAMP)
if I use it on my own database, (eg select first 1 att_patient_examination_dtd from tbl_patient_exam), I get:
22256-10-18. (Data type DATE)
Any ideas what I could do?
Surely the DATE format should work? Other applications like Flamerobin have no such problems on the same field and they don't crash either.