Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Spanish character problem

Re: Spanish character problem

From: wayne <no_at_email.please.com>
Date: 05 Jun 2001 23:42:43 GMT
Message-ID: <9fjqpj$est@dispatch.concentric.net>

You have to pay attenction to what character set your created the database with. If you used ASCII7 then it will not work no matter what NLS_* settings you use. You have to use (as people have pointed out) WE8ISO8859P1 in order to enable extended ASCII (the 8th bit characters, ASCII 128 to 255), or in the most risky move you can use UTF8 to use Unicode, but I would refrain from doing so until you fully understand Oracle's quirks with multi-byte character sets (there is a whole manual section dedicated to national character sets and their correct configuration/use).

Anyway, the first task is to find out how the database was created. Received on Tue Jun 05 2001 - 18:42:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US