Max length of Geofence (polyline)

charm quark5 years ago

Hi, I am trying to create a poly line geofence for approx 1300km eg ( Johannesburg to Capetown) however I get an error

Data truncation: Data too long for column 'area' at row 1 - MysqlDataTruncation (... < QueryBuilder:480 < DataManager:458 < BaseObjectManager:90 < ...)

What is the best way to achieve this ?

charm quark5 years ago

another thought, how about entering the values directly in the msql db ?

Anton Tananaev5 years ago

You would need to increase the column size.

charm quark5 years ago

Thank you.

charm quark5 years ago

Since the Max value of Varchar is supposed to be 65535 , when I would change the value to say 19000, I would get the following error.

" Query error:
#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs"

So I changed the type of tc_gefoences.area from varchar to longtext. It seems to work so far. Any suggestion/advice/pros/cons..