Special characters in flat file output

[thibaut]

Hi,

I need to export data in a fixed width formatted file. If a special character like (ö,ü,ä or ß) is present in a value, the export is wrongly formatted.

For example, if I have the word SÜD and set the export to a WSTRING 3, the output file will have SÜ in it. (input file and output file have both UTF-8 as code page)

I suppose that the designer interprets süd as süd or something like that and cut the last character of the string. 

Do you have any idea on how to fix this?

Regards

[kat]

Hi @thibaut

A special character like ü takes 2 bytes, so you can't set your string length to 3. You'd have to make it 4 bytes in this case. 

You can test it here.

Hope that helps!

Katrin

[thibaut]

Hi Kat,

Yes, that's the point. but if I set the length of a string to be of 3 characters long, I expect it to be 3 characters long.

For me the problem is that the designer concate the string without taking the encoding into account.

Do you have any other ideas?

Thibaut

[MarqueeCrew · Accepted solution]

@thibaut,

Try setting Code Page (#4) to ISO 8859-2 Central Europe in the OUTPUT Tool.

Cheers,

Mark