Re: character set problems

In Article<4o0epk$pj1_at_vivaldi.telepac.pt>, <j_at_mail.telepac.pt> writes:
> Path: news.NetVision.net.il!psinntp!psinntp!psinntp!usenet1.news.uk.psi.net!uknet!tank.news.pipex.net!pipex!dish.news.pipex.net!pipex!news.telepac.pt!host
> From: j_at_mail.telepac.pt (ouuo)
> Newsgroups: comp.databases.oracle
> Subject: character set problems
> Date: Thu, 23 May 96 00:35:58 GMT
> Organization: Conta Própria sa.
> Lines: 22
> Message-ID: <4o0epk$pj1_at_vivaldi.telepac.pt>
> NNTP-Posting-Host: por2_p6.telepac.pt
> X-Newsreader: News Xpress Version 1.0 Beta #4
>
> Hi,
>
> In a project I'm in we were confronted with database with US7ASCII
> character set. We have some applications that will work on that
> database but it must support Portuguese characters. Right now the
> only way we have found to achieve it was to define a client side
> character set HE8DEC. The problem is that this character set wil
> require the manual change of more than 2000 forms/reports v4.5 :(
> which were compiled with WE8ISO8859P1.
>
> Does anyone knows a way to circunvent this ? A full database export
> is not a solution. Is there a character set that is compatible with
> a US7ASCII database and client side forms with WE8ISO ? I've also
> looked ( not deeply ) at Translation Manager from oracle but it
> seems to be too buggy ( VALUE_ERRORS !?!?!, how is this possible
> Oracle ??? ).
>
> I'll appreciate any hints. Post or reply directly.
>
> Thanks in advance.
>
> - Jorge Agra

hi
Try using in oracle.ini user_nls_lang and develovep_nls_lang. The above in some cases can help having the forms in one character set and the data base in another char set. Received on Wed May 29 1996 - 00:00:00 CEST