Topics: |
You can use SET commands in a procedure to determine the collation criteria for sorted data. This parameter can also be set in the LOCALE settings on the Web Console to apply automatically to any procedures created on the Reporting Server for which this SET parameters is not defined. For more information, see How to Change LOCALE Settings on the WebFOCUS Reporting Server.
Set the COLLATION parameter in a procedure to override the COLLATION setting on the Reporting Server.
The syntax is:
SET COLLATION = {BINARY|SRV_CI|SRV_CS|CODEPAGE}
where:
Bases the collation sequence on binary values.
Bases collation sequence on the LANGUAGE setting, and is case-insensitive.
Bases collation sequence on the LANGUAGE setting, and is case-sensitive.
Bases collation sequence on the code page in effect, and is case-sensitive. CODEPAGE is the default value.
In most cases, CODEPAGE is the same as BINARY. The only differences are for Danish, Finnish, German, Norwegian, and Swedish in an EBCDIC environment.
WebFOCUS | |
Feedback |