For a valid CSV formatting, if a field contains a comma then that field must be quoted.
4 separate fields:
2 fields with commas:
3 fields, one with a comma:
If your CSV file is not properly handling literal comma characters like that, it will be very difficult to handle it correctly.
If it is correctly formatted, then we may need to know more about how you're doing the import to make sure it understands how to parse CSV files.
Here are the details, table has fields of Longitude & Latitude and their types are decimal(23,20) for both.
Now, values for this table is stored in the .txt file as, (below is the first row of values for the three fields in the table)
Now, when I try to Import in phpmyadmin with Characterset = utf-8
with Format of Imported file
Fields terminated by= ;
Fields enclosed by= "
Fields escaped by= [/B]
Lines terminated by= auto
After successful Import, it stores the values as
postalcode | latitude | longitude
1020 | 50.00000000000000000000 | 4.00000000000000000000
20 Zeros after decimal are because of decimal(23,20)