From dfa7af5f422ea90f88025754e7f013ab3c6f8306 Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Mon, 29 May 2023 14:30:17 +0300 Subject: Fix broken utf-8 strings in abstract field Signed-off-by: Munyoki Kilyungi --- examples/dump-publication.scm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'examples/dump-publication.scm') diff --git a/examples/dump-publication.scm b/examples/dump-publication.scm index bed957a..b0b35b6 100755 --- a/examples/dump-publication.scm +++ b/examples/dump-publication.scm @@ -55,7 +55,8 @@ ;; separated list. Split it. (map string-trim (string-split (sanitize-rdf-string (field Publication Authors)) #\,))) (set gn:abstract - (sanitize-rdf-string (field Publication Abstract))))) + (sanitize-rdf-string + (field ("CAST(CONVERT(BINARY CONVERT(Publication.Abstract USING latin1) USING utf8) AS VARCHAR(100))" Abstract)))))) -- cgit v1.2.3