MySQL and unity storing Vector3

Hello guys,
Is there a clean way to store a Vector3 from unity onto Mysql? I do not want to store it as a string or individual float numbers. Is there any way to do it. I was able to find a datatype POINT in mysql but it stores only 2 coordinates. Is there any alternative?

Also if you have already done it differently how did you typecast it in unity

Thanks!

I’m not aware of anything more specialized than the POINT type you already mentioned - which isn’t appropriate for 3D data (and somewhat cumbersome to use). You’ll probably need to store the data in 3 individual db fields of appropriate type (FLOAT, DOUBLE, etc).

Why are you against that? It seems a perfectly acceptable solution to me…

It could be overkill/over-engineered, but you could have a table with floats X,Y,Z; have num rouded to 2 decimals, add new entry every time a combo is non-existant or reuse id.