summaryrefslogtreecommitdiff
path: root/contrib/unaccent/sql/unaccent.sql
blob: ede938d4795bddec457b21c56c105748ba766adf (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
SET client_min_messages = warning;
\set ECHO none
\i unaccent.sql
\set ECHO all
RESET client_min_messages;

-- must have a UTF8 database
SELECT getdatabaseencoding();

SET client_encoding TO 'KOI8';

SELECT unaccent('foobar');
SELECT unaccent('£ÌËÁ');
SELECT unaccent('³öéë');

SELECT unaccent('unaccent', 'foobar');
SELECT unaccent('unaccent', '£ÌËÁ');
SELECT unaccent('unaccent', '³öéë');

SELECT ts_lexize('unaccent', 'foobar');
SELECT ts_lexize('unaccent', '£ÌËÁ');
SELECT ts_lexize('unaccent', '³öéë');