Data Type and Length

1

Hi all,

I am trying to find out the length and data type of individual field in my data table.
How do I go about that?

Thanks all in advance

2

Hi @oneflip
You should check your database for those types of information.
You can see some details in Browse Data > Learn about our data (top-right)

3

Hi @flamber

Unfortunately it does not work.
I am trying to write in native enquiry to return back the data type and length
I manage to return data type with data_type and length of charvar with character_maximum_length, however, it doesnt return decimals and integers.

Thank you for being patient

4

@oneflip
What do you mean it doesn’t work?
Which database you’re querying?
Post “Diagnostic Info” from Admin > Troubleshooting.
Post your query.