please share the entire scenario
give us the table DDL and a line of CSV
what are your NLS settings, in particular NLS_NUMERIC_CHARACTERS ?
Happens with every file. I just tried with a test file that contains:
And the test table
It happens with insert and insert script methods. Something to add is that my native language is spanish and I've been importing the configuration profile since 3.X. The issue started in version 4.1 (if I recall correctly), the 4.0.X versions worked fine.
where parameter = 'NLS_NUMERIC_CHARACTERS';
I tried using just the period but still happened
the documentation says
so you should be good (dot should be interpreted as decimal separator indeed)
If you run "select 1/3 from dual", is the separator a dot or a comma ? (presumably a dot according to your prior answer)
Are you using the import wizard for that CSV file ?
the query returns the answer with a dot.
And yes i'm using the wizard.
curiouser and curiouser ;-)
are you by any chance running that insert script under some other tool (e.g. sql*plus) that may default to the en_US locale ?
Nope all work is done in SQLDeveloper
is cp1252 the right file encoding?
Yes it is. I just tested the same import in the 4.0.3 version and the "Insert" method works the right way but the "Insert script" method gives the same result as latest version
can you post up a screenshot of your preferences page for Database -> NLS?
please also share from Help > About > Properties