Even if the database is configured for UTF-8 it still matters how you insert
the data. I’ve had similar problems in the past where the issue was that the
connection to the database was using a different encoding. If memory serves you
have to explicitly set the character set on your ODBC/JDBC/ADO.net connection
string to the appropriate character set as otherwise you can get incorrect
encodings.
Rob
From: Beppe Mazzola <beppemazz...@gmail.com>
Date: Wednesday, 22 February 2017 14:20
To: "virtuoso-users@lists.sourceforge.net"
<virtuoso-users@lists.sourceforge.net>
Subject: [Virtuoso-users] Unable to setup UTF-8 encoding in the relational DB
Hi to all
In order to have Virtuoso relational DB able to correctly store the text with
the UTF-8 encoding I have performed the following operations.
· all the columns with text declared as NVARCHAR(n)
· in virtuoso.ini file
o SQL_UTF8_EXECS = 1
o Charset = UTF-8 ; this is the default value
This is not enough, since I see that the non-Latin characters are incorrectly
stored in the DB yet.
Do I miss any further set-up?
I am using the following Virtuoso Open Source Version
Virtuoso Open Source Edition (Column Store) (multi threaded)
Version 7.2.4.2.3217-pthreads as of Feb 3 2017
Compiled for Linux (x86_64-unknown-linux-gnu)
Thanks!
Cheers
Beppe
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
