Re: Locale setting

Hello, Thanks for the help. It indeed helped me to get some info on the locale setting. I had few addln queries on the locale setting. 1. Is it possible to have different locale (dbs_collate) value for the databases created (dbs_dbsname) ? OR 2. Are the database created should have the same locale value as teh sysmaster ? 3. I am executing the below command to get the locale value and setting the DB_LOCALE, CLIENT_LOCALE, SERVER_LOCALE. Is it the right command ? select dbs_collate from sysdbslocale where dbs_dbsname="sysmaster" On executing the above, I do get only en_US.819 value. But the user created database can have the different locale set. 4. Do we specifically set any locale to the dbspaces .. ? Thanks in advance. ~ Balu