Re: Special characteres.

I have bad news for you: apparently you have your database created in the default characterset which is US7ASCII. For most European countries it should be WE8ISO8859P1 (this is the so-called Latin-1 characterset, dos code page 850). You can try to make sure your PC is running the 850 characterset, but most likely the database is the culprit.
Although there are people that fool around with the sys.prop$ table to change the characterset directly, this method is definitely unsupported by Oracle. You need to recreate your database and make sure the characterset is WE8ISO8859P1.

Good Luck,

Sybrand Bakker, Oracle DBA

Paulo SIlva wrote:

> I have a Oracle database with a front-end in VB5. As you know,
> Portuguese language has some special characters like ã, ç, õ, á, é, etc that
> oracle replaces to a "?" signal. This happens in SQL worksheet when I do an
> "Insert" statement or in VB screen where the data entered.
>
> The question is : How I configure the Oracle or the ODBC driver to
> accept these ?
>
> Thanks in advance,
>
> Paulo Silva
> SMD Informática, SA
Received on Sat Nov 07 1998 - 00:00:00 CST