Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
web:grid2 [2020/04/16 20:53]
agcyphers [Events]
web:grid2 [2020/05/05 10:46] (current)
agcyphers [Common Problems]
Line 210: Line 210:
  
 ==== Common Problems ==== ==== Common Problems ====
 +=== I receive the following Runtime Exception: The data could not be converted to text with this encoding. ===
 +This is a common error when you're loading non-UTF8 data from MySQL for use in Xojo Web projects. To address this issue, you should execute the following commands upon connecting:
 +<code xojo>​myDatabase.SQLExecute("​set names utf8 collate utf8_general_ci"​)
 +myDatabase.SQLExecute("​set character set utf8"​)</​code>​
 +
 === The grid doesn'​t scroll on Firefox for Android === === The grid doesn'​t scroll on Firefox for Android ===
 Due to an incompatibility in Firefox for Android, the Grid's drag scrolling does not function. Attempts to rectify this have failed. For the time being you can workaround this by detecting the device and browser and adding only those rows that would be visible and using pagination. Due to an incompatibility in Firefox for Android, the Grid's drag scrolling does not function. Attempts to rectify this have failed. For the time being you can workaround this by detecting the device and browser and adding only those rows that would be visible and using pagination.