为会话覆盖默认区域设置

您可以通过两种方式覆盖当前会话的默认区域设置：

• VSQL 命令 \locale。例如：

  => \locale en_GBINFO:
  INFO 2567:  Canonical locale: 'en_GB'
  Standard collation: 'LEN'
  English (United Kingdom)
  

• SQL 语句 SET LOCALE。例如：

  
  => SET LOCALE TO en_GB;
  INFO 2567:  Canonical locale: 'en_GB'
  Standard collation: 'LEN'
  English (United Kingdom)
  

这两种方法都接受区域设置的短形式和长形式。例如：

=> SET LOCALE TO LEN;
INFO 2567:  Canonical locale: 'en'
Standard collation: 'LEN'
English

=> \locale LEN
INFO 2567:  Canonical locale: 'en'
Standard collation: 'LEN'
English

另请参阅

• SET LOCALE