PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

SQR Output file UTF-8 special charecters issue

Hello Team,

Special characters on the SQR output file are giving us trouble. When opening, the SQR specifies the UTF-8 file encoding technique. A department description column is sent to the file by this method. This file cannot be loaded by users because of the special character (A with symbol^) below. This particular character is not showing up when I check the database column, but when I use the lengthb() function to check the length, I can see an extra character.

How to avoid these special characters coming over on the file?

eX : description

1234Â Sea Logistics and Supportm


your help would be much appreciated .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center