From b0120413faebeffb41db151d82b07775c754ad15 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Mon, 17 Dec 2018 23:36:25 +0100 Subject: unicode --- README.md | 8 ++++++++ megapixels/app/server/api.py | 2 +- 2 files changed, 9 insertions(+), 1 deletion(-) diff --git a/README.md b/README.md index b3985f18..5c07fa75 100644 --- a/README.md +++ b/README.md @@ -23,6 +23,14 @@ mkdir -p /data_store_hdd/apps/megapixels/faiss/indexes mkdir -p /data_store_hdd/apps/megapixels/faiss/metadata ``` +### MySQL note + +You may need to set the database charset to `utf8mb4` in order to import the CSVs: + +``` +ALTER DATABASE megapixels CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; +``` + ## Building the site ``` diff --git a/megapixels/app/server/api.py b/megapixels/app/server/api.py index b3447eb1..024c32cb 100644 --- a/megapixels/app/server/api.py +++ b/megapixels/app/server/api.py @@ -108,7 +108,7 @@ def upload(name): dists.append(round(float(_d), 2)) ids.append(_i+1) - results = [ dataset.get_identity(_i) for _i in ids ] + results = [ dataset.get_identity(int(_i)) for _i in ids ] print(distances) print(ids) -- cgit v1.2.3-70-g09d2