diff options
author | horchi <vdr@jwendel.de> | 2017-03-05 16:39:28 +0100 |
---|---|---|
committer | horchi <vdr@jwendel.de> | 2017-03-05 16:39:28 +0100 |
commit | e2a48d8701f91b8e24fbe9e99e91eb72a87bb749 (patch) | |
tree | 726f70554b4ca985a09ef6e30a7fdc8df089993c /epglv/README | |
download | vdr-epg-daemon-e2a48d8701f91b8e24fbe9e99e91eb72a87bb749.tar.gz vdr-epg-daemon-e2a48d8701f91b8e24fbe9e99e91eb72a87bb749.tar.bz2 |
git init1.1.103
Diffstat (limited to 'epglv/README')
-rw-r--r-- | epglv/README | 57 |
1 files changed, 57 insertions, 0 deletions
diff --git a/epglv/README b/epglv/README new file mode 100644 index 0000000..089f42e --- /dev/null +++ b/epglv/README @@ -0,0 +1,57 @@ +EPG2VDR Levenshtein Distance for MySQL +Supports UTF-8 insensitive calculation throught iconv. + +Copyright (C) 2013 Jörg Wendel + +Redistribute as you wish, but leave this information intact. + +The build process is integrated in epgd's makefile, to build epglv +separately follow this steps: + +Compiling: +---------- + + Run + make + make install + +Installing UDFs in MySQL: +------------------------- + + Loading UDFs in MySQL, at the mysql prompt call: + + DROP FUNCTION IF EXISTS epglv; + DROP FUNCTION IF EXISTS epglvr; + CREATE FUNCTION epglv RETURNS INT SONAME 'mysqlepglv.so'; + CREATE FUNCTION epglvr RETURNS INT SONAME 'mysqlepglv.so'; + + Check te installtion by: + + mysql> SELECT * FROM mysql.func; + +-----------+-----+-------------------+----------+ + | name | ret | dl | type | + +-----------+-----+-------------------+----------+ + | epglv | 2 | mysqlepglv.so | function | + +-----------+-----+-------------------+----------+ + +Attention: +---------- + + Before changing the lib in MySQLs plugin dir DROP the function if it already exist. + Otherwise you can get mysql in a undefined state and a mysql reinstall may necessary! + +Using epglv: +------------ + + mysql> select epglv(); + ERROR: EPGLV() requires two arguments (string, string) + + First string is compared against second string. + + mysql> select epglv('€uro', 'Euro'); + +----------------------------+ + | epglv('€uro', 'Euro') | + +----------------------------+ + | 1 | + +----------------------------+ + |