search

ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

Can't upload Greek Unicode characters from .csv #680

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Try to upload the attached file into ORDS
2. See that the Greek Unicode characters are replaced with question marks
3. Despair

What is the expected output? What do you see instead?
Bit frustrating this one, as I thought we'd solved all of the Unicode issues.

Please use labels and text to provide additional information.
Chrome. Dev 1.0.14 - 4417

Original issue reported on code.google.com by jajwil...@gmail.com on 12 Jun 2015 at 1:42

Attachments:

GoogleCodeExporter commented 9 years ago 
Sorry - I mangled the file. This is the original as sent via email

Original comment by jajwil...@gmail.com on 12 Jun 2015 at 2:23

Attachments:

GoogleCodeExporter commented 9 years ago 
OK, this works fine in a local install but not in DEV. Will try forcing DB 
creation to use UTF8 encoding regardless of cluster configuration.

Original comment by scott.br...@gmail.com on 12 Jun 2015 at 3:51

GoogleCodeExporter commented 9 years ago 
Passing this to Dave to explain problem to SysDev colleagues

Original comment by jajwil...@gmail.com on 22 Jun 2015 at 9:44

GoogleCodeExporter commented 9 years ago 
Right, I finally, finally, bloody well fixed this.

Turns out console/file reader encoding isn't UTF8 by default on the Dev server. 
So I've forced the file ops to use UTF8 at all times.

I suggest we use a Greek CSV as a test case to prevent regressions.

Original comment by scott.br...@gmail.com on 13 Jul 2015 at 5:04