Re: [libreoffice-users] Re: BasIe - connecting through JDBC

On 4/03/2013 10:49, Fernand Vanrie wrote:
> Heinrich ,
oeps typo : read : Sinds we uses for all our tables UTF-8 we  have no 
encoding problems using OO via ODBC
> 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.thurgood@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+help@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