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 .