Created attachment 142286 [details] demo data *.csv file (utf-8) steps to reproduce: - open Database Wizard and connect to attached *.csv file (you cannot select character set at this time) - open Calc and "Data Sources Browser" - check data - select "Edit DataBase File..." from "Data Sources Browser" TreeView Context Menu and change character set from "system" to utf-8 (Edit/DataBase/Properties.../Additional Settings) - Save - Check Data in "Data Sources Browser" view -> refresh/rebuild has no effect -> only a Disconnect will change the character set
Created attachment 142287 [details] demo *.odb file
Created attachment 142288 [details] db properties
(In reply to Oliver Brinzing from comment #0) > TreeView Context Menu and change character set from "system" to utf-8 > (Edit/DataBase/Properties.../Additional Settings) Edit - Database - Properties does not have Additional Settings :( Arch Linux 64-bit Version: 6.2.0.0.alpha0+ Build ID: dc9ee533dc707cc10b99d537eaccc3ee5aa555fe CPU threads: 8; OS: Linux 4.16; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded Built on June 16th 2018
please have a look at attached picture "db_properties", tab "Additional Settings"
(In reply to Oliver Brinzing from comment #4) > please have a look at attached picture "db_properties", tab "Additional > Settings" Yeah, I am missing the tab.
Created attachment 142937 [details] screen shot after character set change (In reply to Oliver Brinzing from comment #4) > please have a look at attached picture "db_properties", tab "Additional > Settings" it seems to be working for me here. Ubuntu 18.04 and Libo 6.1Beta2 Downloaded the data files, registered the database, opened a new calc file and the data source window there. Selected the datasource and opened it for editing, changed the character support from system to UTF-8. Saved and close the odb file. Back in the beamer window I opened the table and the data displayed all appears as I would expect with UTF-8 as the character set. OK, so I went and opened the odb for editing, again from the context menu in the datasource window and changed the character set to (something else which I was pretty sure would not display the characters properly; cryllic), saved the file, refreshed the tables via the ODB interface and closed the ODB file. Back in the Calc file, the data in the beamer grid has not changed, and I would not expect it to, Base has always IIRC used dirty reads for the table grid control. However, I then grad the table item in the tree view and drag it to the calc sheet, and sure enough the data generates some rather odd looking characters. Screen shot attached. So, it looks to me like it is updating to the change
It still remains though that if you want to see a change in the beamer grid after changing the character set configuration for an ODB datassource the only way is to disconnect and then reconnect by clicking on the Tables or Queries entry in the Database tree view. The same is true for the Base UI. After the connection is created a change to that configuration property will not affect the open connection. The refresh table operation will not update the connection object for this property either. The only option to see the change in a table grid is to drop and recreate the default connection with a macro or the easier, close and reopen the file. In the beamer there are separate connection objects created it appears for viewing data in the beamer grid versus dragging (inserting) data into the sheet and that would explain why the change is picked up there. Since a .CSV File datasource type lists all .csv files in a directory as tables it might be easy to see how a disconnect_reconnect feature would be useful feature. Perhaps not just with a UI exposure at the Beamer but in the Base UI also. Setting the enhancement requests and status to new