Hi Hugh
This should reproduce the problem. In my Virtuoso installation the
Bulgarian text inserted in the test table is different to the one displayed
as a result of the select.
1) Create a user with name test with the following setting.
[image: Immagine incorporata 1]
2) log in as user test
3) Execute the following statements
CREATE TABLE DB.test.HST_FTN
(
FOOTNOTES_ID NUMERIC NOT NULL,
FOOTNOTE_TEXT NVARCHAR(1000) NOT NULL,
CONSTRAINT PK_V_SEM_MRL_HST_FTN PRIMARY KEY ( FOOTNOTES_ID )
);
INSERT INTO DB.test.HST_FTN
(FOOTNOTES_ID,FOOTNOTE_TEXT)
VALUES (4,'След тази дата МДГОВ ще бъде 0,05(*) mg/kg, освен ако не бъде
изменена с директива или регламент.');
SELECT * FROM DB.test.HST_FTN ;
Cheers
Beppe
2017-02-25 22:42 GMT+00:00 Hugh Williams <hwilli...@openlinksw.com>:
> Hi Beppe,
>
> That should be all that is required on the server for Unicode / UTF-8
> support.
>
> Do you have a test case for recreating the problem being observed, which
> should show how the data is being inserted and the queried ?
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
>
>
> On 22 Feb 2017, at 14:20, Beppe Mazzola <beppemazz...@gmail.com> wrote:
>
> 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
> - SQL_UTF8_EXECS = 1
> - 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://slashdot.org>!
> http://sdm.link/slashdot_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
------------------------------------------------------------------------------
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
