we have some perl scripts which loads similar data including spanish content from sybase 12.5 environmen into two oracle 10g database servers say server A, Server B (both running on unix AIX OS environment)
Server A has locale character set of en_US.UTF-8 which displays loaded spanish content without any issues when pointed by java application.
Server B was not set up for character set of en_US.UTF-8. Which does not display some of the spanish accented characters (which displays as some weird reverse '?' etc) when I point the application to this database server. How can i fix the issues on oracle database server B also so that when I point java application to it, it should display special accented characters fine similar to oracle database server A.
Can we install additional locale on server B like UTF-8?. How can we install additional locale on it
Any links, ideas, resources, sample code highly appreciated. Thanks in advance.