Re: [libreoffice-users] Re: Connection to SQL database

Tom,

The initial format and some of the data types would need to be converted 
so the syntax matched to the new . This is a well known problem when 
migrating from one SQL database to another where there are added, 
non-standard data types.

Jay

On 01/15/2014 05:12 PM, Tom Davies wrote:
> Hi :)
> Is it likely to be possible to connect Base directly to the original
> data?  So that instead of getting an export or a dump of the data it
> can be read dynamically?
>
> I know it is not what the o.p. is asking for but i often wonder.
> Regards from
> Tom :)
>
> On 15 January 2014 22:03, Alex Thurgood <alex.thurgood@gmail.com> wrote:
> > Le 15/01/2014 22:08, Carl Paulsen a écrit :
> >
> > Hi Carl,
> >
> > > ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
> > This is enough to tell us that the data came from a mysql database
> > originally. MyISAM is the default engine for non-transactional MySQL
> > databases :
> >
> > http://en.wikipedia.org/wiki/MyISAM
> >
> > In the sample table you give, the table/field definitions are particular
> > to mysql, so if you try to run that sql with another db engine, e.g. in
> > hsqldb via LO Tools > SQL, it will fail because it will not recognise
> > the field types you're trying to create (e.g. enum, mediumint.
> >
> > So, your best bet would be to import that into a mysql server, assuming
> > you have one to hand and you have some kind of console/terminal access
> > (localhost / same machine):
> >
> > mysql < '/path/to/myfiletoimport.sql'
> >
> > optionally with -p if you require authentication for the user that is
> > connecting to the mysql server :
> >
> > mysql -p < '/path/to/myfileimport.sql'
> >
> > There are many web sites on the internet that are full of information on
> > how to set up and import data into a mysql server.
> >
> >
> > Alex
> >
> >
> > --
> > To unsubscribe e-mail to: users+unsubscribe@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

--
Jay Lozier
jslozier@gmail.com


--
To unsubscribe e-mail to: users+unsubscribe@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