Survey - where are free-text answers stored?

[avotaieva]

As the Survey module does not give good overview of free-text answers, I expected to select them from database.
But the query

Code: Select all

SELECT * FROM survey_answer a

does not return any free-text answers.
If I join the survey_questions and survey_answer tables with left join, then I see that there are no entries for the free-text questions.
I am sure to have at least two answers.

Code: Select all

SELECT * FROM survey_question q left join survey_answer a
on q.id=a.question_id

Can anybody give a hint oh that?

Thanks and best regards,