<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - *.csv database: changing character set needs a disconnect" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117813#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - *.csv database: changing character set needs a disconnect" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117813">bug 117813</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>Created <a href="http://bugs.documentfoundation.org/attachment.cgi?id=142937" name="attach_142937" title="screen shot after character set change">attachment 142937</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=142937&action=edit" title="screen shot after character set change">[details]</a> screen shot after character set change (In reply to Oliver Brinzing from <a href="show_bug.cgi?id=117813#c4">comment #4</a>) > 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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>