Date: Thu, 18 Jun 2009 17:54:05 -0400
Reply-To: Dave Taber <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Dave Taber <email@example.com>
Subject: spss export to mysql - problems with non-integer data
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
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
How do I work around this?
Resolution Subject: This has been filed as a defect with SPSS
The behavior changes depending on the driver - however, other
applications, such as Access, can successfully export to MySQL using
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.