Re: forms90 and characterset

On Thu, 24 Apr 2003 15:30:30 +0200, Herr Otto Partz <cris119_at_operamail.com> wrote:

>Hello, I'm testing Forms 9.0.2 against a 9.0.1.3 database (platform:
>SuSE SLES7).
>The database was created with US7ASCII characterset.
>Until now I looked up at my data using MS Access and a browser (through
>9iAS and the PL/SQL Web Toolkit): in both environments Italian
>characters (טאשל) appeared perfectly when setting the client environment
>variable NLS_LANG=AMERICAN_AMERICA.US7ASCII.
>Now I'm not able to force Italian characters to appear in Forms. I tried
> several NLS_LANG settings with no results.
>Do you know a trick to do that?
>
>Thanks in advance. Kind regards,

There isn't, as the characterset of the database is incorrect. European diacritical characters all have the 8th bit set. You need to change the characterset of the database to we8iso8859p15 or mswin1252 by using the alter database characterset command. IIRC the default for all platforms is nowadays 8 bits, it is strange you managed to create a database in US7ASCII, you must have explicitly set that on creation.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Apr 24 2003 - 12:00:45 CDT