Some special characters get mangled on upload

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Import a CSV file containing special characters - e.g. accents, euro 
symbols, etc. (A sample file is attached.)
2. View the data
3.

What is the expected output? What do you see instead?
Ideally, the special characters would display as they do in the original. In 
fact, they appear as black diamonds with question marks in them.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by meriel.p...@gmail.com on 10 Dec 2014 at 3:14

Attachments:

• SpecChars.csv

[GoogleCodeExporter]

We're still having problems importing non-Ascii text into the ORDS, and early 
adopters are complaining about it.

This morning I uploaded the OxRep database that we retrieved from the NSMS 
servers as an SQL dummp into App 1.0.9, but the Greek and accented characters 
have been replaced with the '?' character.

I'm sure we actually had this working as some point in the distant past, so 
it's all rather frustrating.

Upping priority to critical, as it really is one of the biggest bugs these 
days. Also passing to Scott in case he has any new insight as to why this keeps 
happening.

Original comment by jajwil...@gmail.com on 10 Mar 2015 at 1:14

• Added labels: Priority-Critical
• Removed labels: Priority-Medium

[GoogleCodeExporter]

I tried this on my local development environment and everything is fine.

Is the actual data in the database at fault, or just the GUI?

Original comment by scott.br...@gmail.com on 10 Mar 2015 at 2:43

[GoogleCodeExporter]

I can't check how this is configured on Postgres as its deployed on the 
servers, but in my local environment the databases into which data imported are 
all created by ORDS with UTF-8 encoding.

Original comment by scott.br...@gmail.com on 10 Mar 2015 at 2:50

[GoogleCodeExporter]

Handing to Dave...

Original comment by jajwil...@gmail.com on 11 Mar 2015 at 11:52

• Changed state: Started

[GoogleCodeExporter]

Original comment by jajwil...@gmail.com on 11 Mar 2015 at 2:48

• Changed state: Fixed