Mysql data conversion issue
Posted by:
Himz Ar
Date: August 29, 2008 07:32AM
Hi,
Through a java application, I'm trying to migrate some data (which contains special and international characters) to Mysql db 5.0.45.
I'm using jre1.5.0_09
and my mysql connector is 5.0.5
Problem is when i'm tryingto save data with special characters to a longtext field it starts giving following error
Incorrect string value: '\xE2?oSum...' for column 'DETAILS' at row 1
at com.sapient.resultspace.service.ResultSpaceProjectServiceBase.saveProject(ResultSpaceProjectServiceBase.java:256)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
Will using a newer version of mysql connector resolve this issue??
Subject
Views
Written By
Posted
Mysql data conversion issue
4867
August 29, 2008 07:32AM
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.