how to find the default character set of a database schema
Posted on 2009-04-29
I would like to know the default character set of my oracle database schema. There are some spanish content within my schema tables which are displaying good in my local environment but when we promote those table to the client environment using stored procedures some wierd reverse '?' kind of data is dispaying for some spanish characters. I would like to set up same character set that is there in the local machine over there at client place also before running the stored procedures. Any links, resources, ideas, sample code highly appreciated. Thanks in advance.