Cannot retrive data migrated from ms access
Hi,
I have migrated data from MS Access to MySQL. For this I exported the tables to text files and then imported the text files to MySQL DB.
The data has double quotes around it for string values, which is causing problem.
How should I solve this problem?
My project is in JSP.
Sample table from MySQL:
mysql> select * from Status;
+--------+
| Status |
+--------+
| "DR0" |
| "DR1" |
| "DR2" |
| "DR3" |
| "DR4" |
+--------+
5 rows in set (0.01 sec)
Thanks in advance for your help.
Subject
Views
Written By
Posted
Cannot retrive data migrated from ms access
2600
December 31, 2010 04:46AM
1316
January 11, 2011 08:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.