Bug 131465 Fetching date from MySQL returns bogus values
1) In MySQL I have a table with a column of type integer (Year int(11). 2) I run the following SQL statement SELECT date_format(makedate(year, 1), "%Y") FROM census c 3) Which returns the following 1980 1990 2000 4) When I run the same query inside a data set I get the following: 31 39 38 30 31 39 39 30 32 30 30 30 This looks like hex code that is not being translated back to character format.
data/org.eclipse.birt.report.data.oda.jdbc/src/org/eclipse/birt/report/data/oda/jdbc/ResultSetMetaData.java
/*******************************************************************************
 * Copyright (c) 2004, 2005 Actuate Corporation.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *  Actuate Corporation  - initial API and implementation
 *******************************************************************************/
package org.eclipse.birt.report.data.oda.jdbc;
import java.sql.SQLException;
import java.sql.Types;
import java.util.logging.Logger;
import org.eclipse.datatools.connectivity.oda.IResultSetMetaData;
import org.eclipse.datatools.connectivity.oda.OdaException;
import org.eclipse.birt.report.data.oda.i18n.ResourceConstants;
/**
 * 
 * This class implements the org.eclipse.datatools.connectivity.IResultSetMetaData
 * interface.
 *  
 */
public class ResultSetMetaData implements IResultSetMetaData