Re: Accent problem w/ oracle 6 on SCO 4.0

Yann LANGLAIS wrote:
>
> 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.

    You need to set NLS_LANG correctly when you are doing import. Otherwise, your data will be strange.

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