CAN WE DISTRIBUTE UTF-8 ENABELED FLAT FILE USING BODS

[Former Member]

Hi All,

Can we distibute UTF-8 enabled flat file using BODS.

Our requirement is to distribute multilungual data in the file, so we decided to distrubute data in XML as it is UTF-8 enabled.

I heard that if we have windows system and distribute data in flat file, it will not support mutli lingual data as it supports only ansii.

But also seen in the format options that we can didtibute flat file with UTF-8. Please suggest which one is good.

Thanks,

Deepa

[former_member187605 · Accepted solution]

DS can generate UTF-8 flat files without any issue. Just make sure you select the code page in the file format definition.

[Former Member · Accepted solution]

Hi Dirk,

Yes I have selected UTF-8 code page in Flat file format.

Thanks for helping me to take decision.

Deepa

[Former Member · Accepted solution]

Hi Dirk,

Will UTF-8 capable of handling special charecters?

I have some special charecters in the data like * """"" etc becaise of this file data is jumbling like one columns data is sitting in another column for Few records.

Please suggest.

Thanks,

Deepa

[former_member187605 · Accepted solution]

That's what UTF-8 is all about. It is a character set capable of encoding all possible characters in so-called Unicode.