PT 8.54 and HCM 9.2 SQR exract for writing employee names (international language) into fixed length

frHi, We are on Peopeltools 8.54 and HCM 9.2 and we do have HRMS being used by internationally. We ran into below issue now:

SQR program selecting following columns from data base(Oracle) NAMES table and creating extract .dat fille

Fits name

middle name

last name

name suffix

There are certain data in name  field entered using local language key board(international)  causing a problem

After selection WRITE statement is used as follow

Write 1 from

$firtsname:30

$middlename:1

$lastname:30

$suffic:4

we need data in a fixed length format but for names with special characters fields are shifted to left .

Data is displayed correctly on the file only issue is they are shifted left(one space for each Character)