Size of text field

Hi All,
I use ODK collect to pick my data which is submitted to a local server that
is running MYSQL 5

I have a text field in ODK collect, from MYSQL the field size of this
particular field is VARCHAR(255)
Any time data is sent that exceeds 255 characters its truncated. meaning
for all the past submissions that I have am storing half data.
Is there anyway around this for the existing data (is there a way i can
view the truncated text)
Is there anyway around for the subsequent submissions
Any Help will be much appreciated as am already collecting the data

thanks
Ayoub

See
https://opendatakit.org/help/form-design/guidelines/#datastore_string_length

ยทยทยท On Wed, Jan 20, 2016 at 7:30 AM, Ayoub Kakande wrote:

Hi All,
I use ODK collect to pick my data which is submitted to a local server
that is running MYSQL 5

I have a text field in ODK collect, from MYSQL the field size of this
particular field is VARCHAR(255)
Any time data is sent that exceeds 255 characters its truncated. meaning
for all the past submissions that I have am storing half data.
Is there anyway around this for the existing data (is there a way i can
view the truncated text)
Is there anyway around for the subsequent submissions
Any Help will be much appreciated as am already collecting the data

thanks
Ayoub

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com