What data type to store points in?

Question

Yii

Good afternoon,
I'm doing a crop.
I have selection coordinates of 4 of them, what is the best way to store them?
4 fields or points type?
If points, then maybe you can tell me how to handle it easier - to enter data and extract it. Thank you.
Maybe a helper, who saw what?

Answer 1

Given that you will use them 99% of the time in js, it’s easier to store them in json, for which you have a column of type string (100) in the database,
while in php they can easily be turned into an array and back into json using
json_encode() and json_decode

Answer 2

For me, make a normal string field in the database table. Combine coordinates via implode php.net/manual/ru/function.implode.php and extract via explode php.net/manual/ru/function.explode.php . Or do you not need to enter in the database?