/
balmaster
/
postgres
Обзор
Документация
Войти
/
balmaster
/
postgres
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/mb/sql/big5.sql
20 строк
977 B
Bruce Momjian
Included patches make some enhancements to the multi-byte support.
02 фев 1999, 21:51
02 фев 1999, 21:51
a7ad43c
Код
Авторство
О чём код?
drop table �t�Ӹ��; create table �t�Ӹ�� (��~�O text, ���q���Y varchar, �a�} varchar(16)); create index �t�Ӹ��index1 on �t�Ӹ�� using btree (��~�O); create index �t�Ӹ��index2 on �t�Ӹ�� using hash (���q���Y); insert into �t�Ӹ�� values ('�q���~', '�F�F���', '�_A01��'); insert into �t�Ӹ�� values ('�s�y�~', '�]���������q', '��B10��'); insert into �t�Ӹ�� values ('�\���~', '�����ѥ��������q', '��Z01�E'); vacuum �t�Ӹ��; select * from �t�Ӹ��; select * from �t�Ӹ�� where �a�} = '��Z01�E'; select * from �t�Ӹ�� where �a�} ~* '��z01�E'; select * from �t�Ӹ�� where �a�} like '_Z01_'; select * from �t�Ӹ�� where �a�} like '_Z%'; select * from �t�Ӹ�� where ���q���Y ~ '�F�F��[�H�O��]'; select * from �t�Ӹ�� where ���q���Y ~* '�F�F��[�H�O��]'; select *, character_length(��~�O) from �t�Ӹ��; select *, octet_length(��~�O) from �t�Ӹ��; select *, position('����' in ���q���Y) from �t�Ӹ��; select *, substring(���q���Y from 3 for 6 ) from �t�Ӹ��;