You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a German mdb-File that contains multiple tables with column names containing special characters like a slash or a german sharp s (ß) - e.G. "Straße/Postfach". I want to access this file with PHP over odbc.
In generall this database can be read but always when it comes to such a column all ways I tried to access are failing. From PHP in most cases it results in an immediate stop of the script without any error message or errorcode - or with other settings it stops while trying to allocate Giga- or even Terabytes of memory.
As long as I try to access the rows with numeric values it is working for all columns BEFORE such a column. All after it just return null.
When trying to access the same database with command line mdb-sql its working in generall - I can request whole rows and also retrieve this columns withselect * from table it shows up everything. But as soon as I try to select a dedicated column like this: select "Straße/Postfach" from table it crashes with Segmentation fault.
is there a way to set a mode or option or something else to make this MDB-File working with odbc?
I have a unconvenient workarround: with a small python script thats running mdb-schema, mdb-tables and mdb-export, I'm able to create a dump-file that can be imported into sqlite or mysql, so I can work with the data... But I'd like to connect directly to mdb-file because i'd also like to do updates in it...
Regards and Thanks in advance
The text was updated successfully, but these errors were encountered:
I have a German mdb-File that contains multiple tables with column names containing special characters like a slash or a german sharp s (ß) - e.G. "Straße/Postfach". I want to access this file with PHP over odbc.
In generall this database can be read but always when it comes to such a column all ways I tried to access are failing. From PHP in most cases it results in an immediate stop of the script without any error message or errorcode - or with other settings it stops while trying to allocate Giga- or even Terabytes of memory.
As long as I try to access the rows with numeric values it is working for all columns BEFORE such a column. All after it just return null.
When trying to access the same database with command line mdb-sql its working in generall - I can request whole rows and also retrieve this columns with
select * from table
it shows up everything. But as soon as I try to select a dedicated column like this:select "Straße/Postfach" from table
it crashes with Segmentation fault.is there a way to set a mode or option or something else to make this MDB-File working with odbc?
I have a unconvenient workarround: with a small python script thats running mdb-schema, mdb-tables and mdb-export, I'm able to create a dump-file that can be imported into sqlite or mysql, so I can work with the data... But I'd like to connect directly to mdb-file because i'd also like to do updates in it...
Regards and Thanks in advance
The text was updated successfully, but these errors were encountered: