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

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.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