Determining Locales

Problem: Locales

I'm getting errors regarding locales. How do I see what locale my system is set up for?

Solution: sysdblocale

Do a SELECT from sysmaster:sysdbslocale to find your locale setup. The dbs_collate value is the name of the locale you are set up for. You can also run the following query against the database in question:

SELECT site from systables where tabname = " GL_COLLATE"

The first character in the tabname is a SPACE, so the tabname is "<SPACE>GL_COLLATE."