Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

  

16 Comments
Labels in this area