I'm working with VDP 7.0 and I have [this CSV file](https://openflights.org/data.html#airport) that amongst other airport-related data contains latitude and longitude information.
Here's a sample row of the dataset so you don't have to download the whole file:
34,"Castlegar/West Kootenay Regional Airport","Castlegar","Canada","YCG","CYCG",49.2963981628,-117.632003784,1624,-8,"A","America/Vancouver","airport","OurAirports"
Seems reasonable enough to me to convert fields 7 and 8 (lat, lon) to float, double or even decimal, but when doing so I seem to lose the decimal point all together, resulting in _492963981628,00_ to be shown. The point instead is correctly displayed when querying the same view but with such fields typed as originally as text.
Things I tried:
- converting the fields using the Edit tab of the base view, from the Field Type column dropdown
- creating a new Selection view, using CAST with such fields
Used both methods trying out others than my own locale (it_euro), which uses commas instead of dots for floating point notation (changed it in _Tools_ > _Admin Tool Preferences_ > _Locale_, even ticking _Internationalize query results_). CSV was imported locally using _,_ as column delimiter, _\n_ as EOL delimiter, automatic encoding detection and _Ignore matching errors_ ticked.
Is there anywhere else I can change the locale? Am I doing something wrong elsewhere?
Thanks in advance!