Spanish into Oracle

Hi all,

Is there a way to insert spanish words into the Oracle table - like 'España'.

When I try to insert it, it either takes the ASCII counterpart of it or replaces the 'ñ' with a '?'.

Has anyone done this before or knows a work around for it??

Shiva.

First you have to define in the init.ora a character set which supports the Spanish characters. Second you have to set the nls_settings on your client correct, else the characters can/will be converted.