haezeban
Programmer
- Mar 13, 2013
- 3
In our Progress (V9.1B) the codepage used is ibm8858-1. On a unix sco machine.
In Progress I dump data as follows : export stream strA to /u/usr/ppd/tesk.txt convert target "1252".
for each tab1 no-lock : put tab1.field1 ";" tab1.field2 skip. end.
When I use vi to open de file is see the french words as follows : Apr\212s in stead of après.
Normally I ftp that file to a PC and then via a dtsx I load it in sql.
But in sql the french characters are also not in the correct format.
Does somebody knows how I have to export the data (text) and how I need to import it in sql (2005) . Now I also use codepage 1252 in my dtsx.
Tkx, Jac
In Progress I dump data as follows : export stream strA to /u/usr/ppd/tesk.txt convert target "1252".
for each tab1 no-lock : put tab1.field1 ";" tab1.field2 skip. end.
When I use vi to open de file is see the french words as follows : Apr\212s in stead of après.
Normally I ftp that file to a PC and then via a dtsx I load it in sql.
But in sql the french characters are also not in the correct format.
Does somebody knows how I have to export the data (text) and how I need to import it in sql (2005) . Now I also use codepage 1252 in my dtsx.
Tkx, Jac