koobas.hobune.stream
Unity does not read floats from MySQL
I created a simple MySQL database with just one table (POSITIONS) with three fields: id, posx, posy. Id is an integer and posx and posy are floats. I copied the Mysql.Data.dll to a Plugins folder in the Project window. To read the data from the table I used
MySqlConnection conn=new MySqlConnection(...); // I used a string connection
var command=new MySqlCommand("SELECT * FROM POSITIONS");
conn.Open();
MySqlDataReader reader=command.ExecuteReader();
reader.Read();
int id=reader.GetInt32(0); // the id field
float x=reader.GetFloat(1); // the posx field
This does not work. Unity gets stucked for a few minutes until I get an error message.
Any ideas?
Thank you !
