Heinrich ,
Sinds we uses for all ore tables UTF-8 we (never) have encoding problems
using OO via ODBC
Hello Alex,
I create ALL tables with
.
.
CHARACTER SET latin1 COLLATE latin1_german1_ci
.
This should obviously allow for o-Umlaut etc....
In LO I specify ISO-8859-15/EURO for the codepage within the properties
dialogue for the .odb files.
You are most likely right about the "display glitsch" in both JDBC and
ODBS.
And, yes, it seems to happen more under ODBC.
Regards
H
On Mon, 04 Mar 2013 09:00:27 +0100, Alex Thurgood
<alex.thurg...@gmail.com> wrote:
Le 02/03/2013 14:10, Heinrich Stoellinger a écrit :
Hi Heinrich,
Hello,
Seeing as the Native MySQL-connector seems to be a "difficult" birth -
I tried both ODBC and JDBC lately. Unfortunately both seem to be
unusable!
JDBC: I cannot get it to accept German special characters (even
though I
specify codepage ISO-8859-15/EURO).
Where did you specify the codepage ? In the connection string ? Or is it
simply an option of the table to which you are writing ?
Also, when inserting you rows into the database, both with JDBC and
ODBC,
string default values are shown with apostrophies at the beginning
and end.
If one then re-selects the row, the fields are shown correctly
(i.e. without the apostrophies). This might be kind of o.k. for me as I
have around 30 years of IT-experience behind me, but certainly NOT
o.k. for
the average uninitiated user...
Seems like a display glitch/bug...reported bug ?
ODBC: default values as specified within a table creation show kind of
"random"
values in columns of inserted tuples. When refreshing the display or
re-selecting
the tuplethe values are displayed correctly.
Could be the same or similar bug to the one your describe above.
Refreshing datasets still seems to be a problem sometimes. I have
noticed that more so with ODBC than JDBC.
Alex
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
