Every time I open a CSV (comma separated values) document in OpenOffice.org Calc I get a dialog with CSV preferences.
The current default character set is "Eastern Europe (ISO-8859-2)".
I would like "UTF-8" to be selected by default instead.
The problem was in LC_ settings in my system. It was set to:
which probably defaults to ISO-8859-2. After altering this to:
Everything is ok. CSV defaults to UTF-8.
I think this is controlled by your Locale Settings.
For me CSV files default to UTF-8
In Tools > Options > Language Settings > Languages.
My Locale is set to default. My Language is set to English (UK)
The Locale of the PC is English (UK)