summaryrefslogtreecommitdiff
path: root/epglv/README
diff options
context:
space:
mode:
authorhorchi <vdr@jwendel.de>2017-03-05 16:39:28 +0100
committerhorchi <vdr@jwendel.de>2017-03-05 16:39:28 +0100
commite2a48d8701f91b8e24fbe9e99e91eb72a87bb749 (patch)
tree726f70554b4ca985a09ef6e30a7fdc8df089993c /epglv/README
downloadvdr-epg-daemon-e2a48d8701f91b8e24fbe9e99e91eb72a87bb749.tar.gz
vdr-epg-daemon-e2a48d8701f91b8e24fbe9e99e91eb72a87bb749.tar.bz2
git init1.1.103
Diffstat (limited to 'epglv/README')
-rw-r--r--epglv/README57
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 |
+ +----------------------------+
+