Date:         Thu, 18 Jun 2009 17:54:05 -0400
Reply-To:     Dave Taber <dave@novaquant.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Dave Taber <dave@novaquant.com>
Subject:      spss export to mysql - problems with non-integer data
In-Reply-To:  <503321.37135.qm@web82002.mail.mud.yahoo.com>
Content-Type: multipart/alternative;

we can't seem to export non-integer numeric data to mysql via ODBC --
listed below is a problem shown on the spss support site from 2006
and reviewed in 2008

does anyone know if there is a work-around on this issue or whether
SPSS is doing anything about it

i'm using spss 16 and my colleague is using spss 15 -- we're both
using 3.51 ODBC driver

thanks
dave




Resolution number: 62478  Created on: Jan 27 2006  Last Reviewed on:
Jan 26 2008

Problem Subject:  Problems with exporting data from SPSS into MySQL

Problem Description:  I am using SPSS for Windows and I'm having some
problems trying to export data out of SPSS into MySQL database with
the Save Translate command syntax. Using the recommended 3.51 MySQL
ODBC driver, I cannot export dates or numeric fields with decimals
defined. All of the numeric values with decimals export to MySQL as
zeros, and variables defined as dates do not export at all, and the
following warning appears in the Output Viewer:

 >Warning # 6480. Text: MYDATE
 >Variable has been dropped - it's type is not supported by the data
base

How do I work around this?

Resolution Subject: This has been filed as a defect with SPSS
Development.

Resolution Description:
The behavior changes depending on the driver - however, other
applications, such as Access, can successfully export to MySQL using
both drivers.

If you are using the mySQL ODBC driver version 3.51, you cannot save
date or datetime fields to MySQL. You will recieve an error message
saying that the type is not supported by the database.

If you try to export time formats, or non-integer data (F8.2) data,
SPSS will create a field defined as double, but all the data will be
set to 0.

If you use the 2.5 driver, it can successfully export date and
datetime fields, but non-integer and time data still saves as zeros.

This has been filed as a defect with SPSS Development and we
apologize for any inconvenience.





[text/html]