I am trying to figure out what I can do about this.
I have a SAP Table. To be specific, it is PLKO. I have a column - KTEXT
For a specific PLNNR, the source system - SAP shows a Character as a ‘#’ symbol
However, when I view that record in DS - View Data Glass, I see it like -> Symbol (Something like the Right Arrow symol inside the circle in this Emotion )
I have setup the Datastore Codepage as utf-8. Inspite of this, I am get this (box kinda) character…
We are going mad at this…
We are in DS 4.0 SP1. Shall I go change the Codepage stuff in DSCONFIG?
Also, when I write into a Flat File with utf-8 setting, still only the box come up.
Are you sure it is a code page issue (it could be a weird character)? If you import and view data of the standard SAP table T005T for country names, and you properly see the countries with all sorts of accent marks, then I would think your code page is setup correctly. In which case, it could be a loss of translation during utf-16 to utf-8 for that particular character.
So are you saying the data is loaded fine but the Data Preview of DataServices does something funny? That could be, e.g. when the Designer Font does not contain an image for this character.
ganeshxp I am a bit puzzled about this. With your expertise this should have been a piece of cake
The only thing I can think of is that the # shown in SAP is some crap data: row delimiter, end of file marker etc.
As an ultimate test you can edit a field in dev/qa SAP system and enter some russian/chinese data there. Romanian is also cool. If you can extract that data correct, then I would make the assumption that you do not have a codepage problem.
Do you have multiple data store configs, and have you loaded data into one that’s not the default? (Isn’t it the case that the data viewer “magnifying glass” thing in the Designer shows you data from the default data store configuration? I think that’s true.) (And, if it is true, I have a feature request: prompt for selection of a data store configuration when using the viewer.)
I have seen the right arrow symbol and a black triangle with a question mark inside . I corrected it by moving away from the utf-8 code page setting to cp1252 and esnuring my sql field was not nvarchar
It was a mismatch of codepages, maybe too simple for this i know but just for ref what happened in my instance of seeing the character.
)
(BOB member since 2008-07-17)
(BOB member since 2004-12-17)
(BOB member since 2012-03-20)
(BOB member since 2012-03-20)