Hello,
I have a csv file which should be loaded in a target table. The problem is I cannot visualize data when using View Data in the model representing the file.
As far as I can see file encoding is UCS-2 Little Endian (checked with Notepad ++ and another online tool - File Encoding Checker - Home).
So I tried to set encoding in JDBC Url in the topology. I tried all of them:
- jdbc:snps:dbfile?ENCODING=UTF-8
- jdbc:snps:dbfile?ENCODING=UTF16
- jdbc:snps:dbfile?ENCODING=UTF-16
- jdbc:snps:dbfile?ENCODING=UTF-16LE
- jdbc:snps:dbfile?ENCODING=x-UTF-16LE-BOM
- jdbc:snps:dbfile?ENCODING=UTF-32LE
- jdbc:snps:dbfile?ENCODING=x-UTF-32LE-BOM
- jdbc:snps:dbfile?ENCODING=UTF_32LE
- jdbc:snps:dbfile?ENCODING=UTF_32LE_BOM
- jdbc:snps:dbfile?ENCODING=UnicodeLittleUnmarked
- jdbc:snps:dbfile?ENCODING=UnicodeLittle
None of them helped to show the file data.
Moreover when I perform reverse engineering to read column names, they are shown with underscores between every two symbols.
For example:
Original column name in file: Date
Displayed name after reverse engineering: __D_a_t_e_
I would appreciate any ideas helping me to solve the problem.
Many thanks.