Page 1 of 1
Portugese character issue
Posted: Wed Jun 24, 2015 11:02 pm
by Developer9
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?
Posted: Thu Jun 25, 2015 2:06 am
by ArndW
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.
Posted: Thu Jun 25, 2015 8:04 am
by Developer9
Thanks for the reply, I am using the same character set in the seq file also , i tried textpad , notepad++ and Ultra edit all of them show the same issue
Textpad
Posted: Thu Jun 25, 2015 9:26 am
by ozgurgul
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
Re: Portugese character issue
Posted: Sun Jun 28, 2015 8:53 pm
by weiyi_will
What's encoding on Oracle side? It may work if you set NLS to UTF-8 and update this field toNvarchar.