Loading special characters from a flat file to target table

[Former Member]

Scenario:

     To load special characters such as non-English characters  from a flat file(.txt) to target table whose code page is set to UTF-8 .

In order to load special characters from a flat file to target table we need to set appropriate code page or encoding   in :

a)   a)    In the source file

We need to set the encoding of source file to utf-8. This differs based on the text editor we use. Below mentioned are the steps for changing the encoding in notepad.

File --> Save As . Change the encoding to UTF-8

b)    b)   Flat file properties.

    In BODS, normally the code page is set to <default> in flat file properties  as given below:

     Change it to utf-8.

    

c) Datastore properties

    Go to the target data store properties in BODS. Normally the code page is set to <default> as given below:

      Change Code page and Server code page to utf-8.