Portugese character issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 187
- Joined: Thu Apr 14, 2011 5:10 pm
Portugese character issue
I am using oracle connector to extract data, using the NLS mapping specified by the database owner (ASCL_ISO8859-15). When i do a view data in the oracle connector stage the data looks fine , but when i open the text file after extracting the data looks messed up eg(Funcionário1). Could anyone throw some light on this?
What character set is your text file being written in, and which tool are you using to view the data?
It is most likely that the data was read and processed correctly; but that there is a character set disjunction upon reading it.
It is most likely that the data was read and processed correctly; but that there is a character set disjunction upon reading it.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 187
- Joined: Thu Apr 14, 2011 5:10 pm
Textpad
Hi - It sounds like it is only presentation issue (since the right codepage is chosen) If I were you, on my textpad (v7.4.0) editor after I open the file I would have right-clicked and double-checked the properties of the doc at the document tab and verified that code set is correct.
In addition to that, you would verify the script is set to "western" at the combobox in "Font" Tab.
Cheers,
Ozgur
In addition to that, you would verify the script is set to "western" at the combobox in "Font" Tab.
Cheers,
Ozgur
Ozgur GUL
Assumption is the mother of all mistakes!
Assumption is the mother of all mistakes!
-
- Participant
- Posts: 10
- Joined: Sun Aug 11, 2013 10:46 pm
- Location: Dalian
Re: Portugese character issue
What's encoding on Oracle side? It may work if you set NLS to UTF-8 and update this field toNvarchar.