lang::util::lang_sort (public, deprecated)

 lang::util::lang_sort field [ locale ]

Defined in packages/acs-lang/tcl/lang-util-procs.tcl

Deprecated. Invoking this procedure generates a warning.

Each locale can have a different alphabetical sort order. You can test this proc with the following data:

    insert into lang_testsort values ('lama');
    insert into lang_testsort values ('lhasa');
    insert into lang_testsort values ('llama');
    insert into lang_testsort values ('lzim');
    

DEPRECATED: this api only supports Oracle. It also uses hardcoded mapping between language and collation. It is unclear if an api is needed for this, or if one can just have database-specific SQL in xql files in order to achieve cross-db collation behavior.

Parameters:

field (required)

Name of Oracle column

locale (optional)

Locale for sorting. If locale is unspecified just return the column name

Returns:

Language aware version of field for Oracle ORDER BY clause.

Author:

Jeff Davis <davis@xarg.net>

See Also:

• https://www.postgresql.org/docs/current/collation.html
• https://docs.oracle.com/cd/B14117_01/server.101/b10759/functions089.htm

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.