 | | | Importing a separated file into mysql, national charset problem?? | Importing a separated file into mysql, national charset problem?? 2005-02-13 - By Oddvar Kragseth
Back
I'm importing a file into mysql.
Most work fien, but numbers are given like this :
`487,90`116,40`4467,00`
This creates a problem, as the decimal numbers are NOT read... i.e i get 487.00
, 116.00 in my database.
Is this a "national" problem as we use komma as a decimal seperator in Norway?
Do i set this in windows or in LOAD DATA INFILE statement??
Oddvar Kragseth
Earn $52 per hosting referral at Lunarpages.
|
|
|