Re: Accent problem w/ oracle 6 on SCO 4.0

Yann LANGLAIS wrote:
>
> Hi,
>
> We have a bad time trying to import accentuated data
> into oracle database. The normally accentuated characters
> appearm once loaded as a normal ascii char, but shifted.
> That is, for example, "é" becomes something like "j", in q string
> resulting from a query.
>
> I may guess that the problem comes from a 8 to 7bits rough conversion,
> or something similar.
>
> Did someone experienced such a problem and found a fix???
>
> All help is welcome.
>
   

   As you are using Oracle 6, you need specify CHARSET parameter during import instead of setting NLS_LANG.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841