Special Characters

435 Views

I am loading into a DSO via flat file. In the flat file, there is a record with a strange character:

credit denied. 04/01/09 âu20ACu201C We pulled the

When I pull the data into the PSA, it looks like this:

credit denied. 04/01/09 a## We pulled the

When it goes from the PSA to the DSO, it looks like this

CREDIT DENIED. 04/01/09 Âu20ACu201C WE PULLED THE

The only transformation rule for the for that field is TOUPPER.

I have also tried to enter u20AC into the permitted characters, but when I execute it, it converts from u20AC to #.

What is strange to me, is I don't have any trouble loading this file into BW. We get the error regarding invalid character when we execute the query.

I would have thought if BW does not like the character, it would not allow me to load it into the DSO.

Thanks, Keith J