Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

segmenataion fault with column names containing special characters #411

Open
renky opened this issue May 17, 2023 · 0 comments
Open

segmenataion fault with column names containing special characters #411

renky opened this issue May 17, 2023 · 0 comments

Comments

@renky
Copy link

renky commented May 17, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant