Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-10-18 08:29 AM

UTF-8/ANSI problem

Hi

I have a file which contains characters as for example ö. Using Studio in Windows and read data from this file and save it to a table in Oracle, I can see that the characters are stored in the table as they should. If I build the job and run it from a Windows CMD prompt, somehow the string are converted to ANSI (ISO-8859-15) and stored as such in the Oracle database. So ö is shown as Ã.

Does anyone have experience - and the solution - with this?

Best regards, Lise

Labels (2)
Labels
556 Views
0 Likes
4 Replies
Anonymous
Not applicable
‎2015-10-18 09:35 AM
Author

Take a look at the advanced settings of your file input component. By default the encoding is set to ISO-8859-15. Try changing this to UTF-8.
However, the behaviour shouldn't change between Studio and the compiled job. This might be a bug.
556 Views
0 Likes
Anonymous
Not applicable
‎2015-10-20 04:05 PM
Author

Hi rhall_2.0

The encoding is allready set to UTF-8, and that is why I dont understand the outcome.

Best regards, Lise
556 Views
0 Likes
Anonymous
Not applicable
‎2015-10-21 05:22 AM
Author

hi,

strange behavior  0683p000009MACn.png
which Talend version are you using ?

regards
laurent
556 Views
0 Likes
Anonymous
Not applicable
‎2015-10-28 03:33 PM
Author

Here is the version information:
Version: 5.6.1
Build id: V5.6.1_20141207_1530
556 Views
0 Likes