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--