Re: Character set

"A. López" wrote:
>
> Hello,
>
> I am working with Oracle 8.0.5 for AIX 4.2 and I have some troubles when I
> try to work with special spanish characters.
>
> Can you tell me which is the file who stores that information? and if it is
> possible which the correct value to work with spanish character set?
>
> Thanks in advance, A. Lopez

First of all, check what is the characterset of your database. No matter what characterset you are using, the important thing is it should an 8 bits characterset. In case your database has a 7 bits (eg uS7ASCII), all your spanish character have probably be converted to 7 bits. To check the characterset of your database, you can do : SELECT * FROM sys.props$;

Second, all your client you should have NLS_LANG set to for example spanish_spain.we8iso8859p1 or american_america.we_iso8859p1, or anything else. The important thing is the characterset. Generally for Unix or Windows NT it is we8iso8859p1 (Western Europe)

If you use these settings, all your spanish characters should be OK. To change the characterset, you need to recreate the database, and specify the character during the create database. Received on Mon Jul 12 1999 - 15:39:26 CDT