Forms3 conversion of Spanish punctuation to nonsense??

[Ray Chance]

I have a list of reference values that includes both Spanish and English
headings - the users may pick either. In the database table, it is stored
correctly and displays correctly in SQL*Plus. However, in Forms when used
in a list-of-values, Forms converts the spanish characters with punctuation
to a different, english character. Example: in the table I have the values
"Tele(with-an-accent)fono - Compan(with-a-tilde)i(with-an-accent)es De". It
displays in Forms as "Telifono - Compaqmes De". For clarification, let's
drop the punctuation and here's what I have:

In Spanish (no punctuation): Telefono - Companies De
In Forms3.0 : Telifono - Compaqmes De

Anyone have a clue how I can at worst display the Spanish characters but with
no punctuation so at least the letters are correct, or at best display the
Spanish correctly??? I'd hate to think (shudder) of writing a translate()
statement for every possible Spanish letter....

[Ray Chance]

Ray Chance (rch...@netcom.com) wrote:
: I have a list of reference values that includes both Spanish and English

: headings - the users may pick either. In the database table, it is stored
: correctly and displays correctly in SQL*Plus. However, in Forms when used
: in a list-of-values, Forms converts the spanish characters with punctuation
: to a different, english character. Example: in the table I have the values

(stuff deleted)

: In Spanish (no punctuation): Telefono - Companies De

: In Forms3.0 : Telifono - Compaqmes De

FYI - I received a private mail reply - it's the good ole 7 bit vs 8 bit
terminal display issue.

We need to invoke the forms using a 8 bit term file, AND to make
sure the terminals in use (there are a variety) can display the 8 bit
char. set.