Siebel Consultant Diary of a Siebel Consultant

Siebel converts special characters

Today I was working on the dataload from a Siebel 6 environment to a Siebel 7.8 environment. When I try to import the attachments into the new environment, I found that a lot of attachments where partially imported.

A look at the logfile learned me that those attachments could not be found. After a closer look, it seemed that all the attachment had special characters in the filename. With special characters I mean characters like é, è, à % and so on.

After comparing some of the attachments I noticed that Siebel converts these characters in other characters. So far I made this list of converts. The list is not yet complete but maybe it can be helpful:

ô –> (
é –> T
è –> F
ï –> n
û –> v
à –> a
ê –> O
î –> á
² –> ¦
ö –> ÷
ç –> t
% –> blank
€ –> Ç
’ –> Æ
« –> ½
» — > +