Re: Help with junk characters

Laurenz Albe a écrit :

> To get a good response, please clarify what you did and what your
> problem is.
>
> - How did you "generate data for use with SQL Loader from access database"?

using omwb97.mde which is msaccess exporter tool and part of Oracle Migration Workbench.

> - Please give an example of the junk characters.

The original .dat generated with Migration toool contains for instance: <EOFD>Fait Mise à jour du taux d'accident du travail appliqué à un établissement<EOFD>

after transferring it to unix:
<EOFD>Fait Mise à jour du taux dâaccident du travail appliqué à un établissement<EOFD>

There's no problem when I put this single line into new file and I transfer it. The problem is when I transfer the whole .dat file.

> - What is "migration tool"? What is "ftp tool"?

I tried with FileZilla and WS FTP.

> I bet you that your problem is the following, correct me if I'm wrong:
>
> Your Windows data contain some of the dreaded "spoil data transfer to
> non-Windows systems" characters.

What you have said next explains part of problem. It's true in case of character ' typed in MS word. When I transfer a file containing the single line above, the transferred file looks like this (all ok except '):

<EOFD>Fait Mise à jour du taux daccident du travail appliqué à un établissement<EOFD>. Received on Thu Nov 03 2005 - 10:47:45 CST