[Libreoffice-bugs] [Bug 117813] *.csv database: changing character set needs a disconnect

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=117813

--- Comment #6 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Created attachment 142937
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142937&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180619/897d88cb/attachment.html>