Which data type in MySql to store answers form different question type

[stephanealoo]

Hi @MatB
Welcome to the community forum. I would break your questions into multiple segments as below

@MatB

In particular, I would like to know which MySql data type is the best to store the answers to text questions and GPS coordinates.

These are text data

@MatB

I’m also searching the data type of ‘start’ and ‘end’ (that I set to be automatically acquired in the form settings). Is it a standard data format or is it a custom made format?

You should note that this data contained is actually the start time and includes the date in it. I would refer you to the following topic for you to look at

How can I change the default date format?

Thanks a lot, @Xiphware. Do you show me how should I write? I have tried, but not working. [date-error]

Stephane