Skip to main content
Question

Data migration - special characters, new lines


Forum|alt.badge.img+3
  • Do Gooder (Customer)
  • 2 replies

Hi,
I am trying to migrate data into Aps10 Upd10 using csv as input file. The data has newlines, tabs and some special characters like £,€,©,º,≠,≈


When the data has newlines, the CREATE_TABLE_FROM_FILE job reads it as the next record. I have to remove the newlines from the data if i have to load them correctly. Is there a solution for this so that i can retain the newlines in the data?

 

Also if the data has special characters like º,≠,≈ , then the csv file doesn’t display them properly. Hence when I load the data into IC table, it replaces these characters with ‘?’.
Some of the character do work fine like £,€ . Is there any list of special characters that is not supported when using csv migration?

 

Kindly guide.

2 replies

Forum|alt.badge.img+6
  • Do Gooder (Customer)
  • 9 replies
  • April 20, 2022

Hallo,

have you tried to change the Character set?

regards

André


Forum|alt.badge.img+11

@naija Did you manage to get a resolution for this issue?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings