Skip to Content

Loading special characters from a flat file to target table

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

/wp-content/uploads/2013/07/1_250912.png

b)    b)   Flat file properties.

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

/wp-content/uploads/2013/07/2_250919.jpg

     Change it to utf-8.

     /wp-content/uploads/2013/07/3_250920.jpg

c) Datastore properties

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

/wp-content/uploads/2013/07/4_250921.jpg

    

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

   /wp-content/uploads/2013/07/5_250922.jpg

16 Comments
You must be Logged on to comment or reply to a post.