Re: how to load non english numbers + date-format ?

[Lao De]

Hi,

There is no application on top.

I'm just looking for the syntax, how to laod different than english formats (numbers, date) from a flat-file.

I can't find anything in the documentation.

An easy sample of how to convert a number like 1.234,56 while loading it, would be enough to help.

I use to load data like this:

LOAD DATA LOCAL INFILE 'C:/data-path/source_file.txt' INTO TABLE mytab columns terminated by ';' IGNORE 1 LINES;

Do I have to use some other function to load include convert ?
Do I have to change my session-context to match national date/number formats ?

can I tell "LOAD" somehow about the number and date-format, as it comes in flat-file ?

In MySQL Reference Manual 5.1 I can't find a chapter about loading details. May be there are other documentation I need ? which ?

Please turn my head to docu-direction or tuotrial, which is not to cryptic. I want to use the tool, not becoming a scientist about the tool.

thanks for any hint, LaoDe