Importing a separated file into mysql, national charset problem??

Importing a separated file into mysql, national charset problem??

am 13.02.2005 15:35:23 von Oddvar Kragseth

------=_NextPart_000_0006_01C511E1.A2591CB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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.
=20
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
------=_NextPart_000_0006_01C511E1.A2591CB0--