MySQL Forums
Forum List  »  Newbie

Re: how to load non english numbers + date-format ?
Posted by: Lao De
Date: April 28, 2011 04:34AM


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

Options: ReplyQuote

Written By
Re: how to load non english numbers + date-format ?
April 28, 2011 04:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.