[TYPO3-dev] TCA - table versions - save mysql practice

[Achim Gerber]

Hi All,

I am developing quite a complex application to research chinese style
characters.

A lot of the research was done with excel style tables and I need to
come up with some kind of import scripts...
To access data I plan to use the eID  mechanism in TYPO3. This way this
scripts and also my AJAX application can use them.

I really like how extensions handle mysql tables. If a new version of
the extension is making structural changes they can be committed to
mysql with the intall tool - all very good.

My question now: From my little understanding ext_tables.sql holds the
table definitions. How can I now in my code use TCA definitions of that
table to check the incoming data that I don't risk any sql injections.

Could you please point out some script examples to me how I could
evaluate a give array before writing to that table...

Hope you understand my question...
Greetings - Achim