Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help with junk characters

Re: Help with junk characters

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 03 Nov 2005 19:24:45 +0100
Message-ID: <dkdk40$qkm$1@news6.zwoll1.ov.home.nl>


News wrote:
> 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>
>

How do you check that? Is it not simply a problem with the tool you use to check? What about setting your language to MSWIN1252 for the SQL*Loader session, and checking what come out of the database?
-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Thu Nov 03 2005 - 12:24:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US