创建用户定义字符集

要创建用户定义字符集，请使用 etx_CreateCharSet() 例程来指定新字符集的名称和包含该字符集定义的操作系统文件的位置。

例如，要从存储在 /local0/excal/my_new_char_set_file 中的定义中创建名为 my_new_charset 的用户定义字符集，请执行以下语句：

EXECUTE PROCEDURE etx_CreateCharSet 
    ('my_new_charset', '/local0/excal/my_new_char_set_file');

操作系统文件必须包含 16 行数据，每行由 16 个十六进制数字组成。每个位置都与一个特定的 ASCII 字符对应。如果希望对位置中的字符建立索引，那么请输入应该索引为的字符。如果不希望对该字符建立索引，请输入 00。

样本文件 /local0/excal/my_new_char_set_file 支持对所有字母数字字符以及连字符（十六进制值为 0x2D）建立索引。另外，它将小写字母映射为大写字母。

# Character set that indexes hyphens and 
# alphanumeric characters. All lower case letters
# are mapped to upper case.
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 2D 00 00
30 31 32 33 34 35 36 37 38 39 00 00 00 00 00 00
00 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
50 51 52 53 54 55 56 57 58 59 5A 00 00 00 00 00
00 41 42 43 44 45 46 47 48 49 4A 4B 4C 4D 4E 4F
50 51 52 53 54 55 56 57 58 59 5A 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00

要在创建 etx 索引时使用该用户定义字符集，请将 CHAR_SET 索引参数设置为 my_new_charset。如果没有在 CREATE INDEX 语句中指定 CHAR_SET 索引参数，那么缺省情况下使用 ASCII 字符集。