MySQL Forums
Forum List  »  Other Migration

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??

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql data conversion issue
5042
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.