MySQL Forums
Forum List  »  Performance

Re: Chinese data not appraing
Posted by: Ra Nala
Date: December 09, 2015 01:04AM

thank you for your suggesition, i wil try it out.

i have raised my question long back on pentaho forum but no one has replied.

I hope issue may be with MySQL as well not only with PENTAHO.

I can basic example foe another type of scenario why it is not only with PENTAHO.

I have data like in my SOURCE database : "Reason for vehicle is DESCRPTION" when i am trying to extract the data using PENTAHO , i got error why because the data is having size upto 1000 characters after this statement, might be cuustomer given spaces after this statement. "Reason for vehicle is DESCRPTION"

I can generally use , inteally i thought that issue is with PENTAHO but finally issue is with MySQL.

select
repair_descr
from abc

but to avoid issue i need to write query as like below
select
REPLACE(repair_descr, '\n', '') as reason_repair_descr
from abc

Options: ReplyQuote


Subject
Views
Written By
Posted
1622
November 25, 2015 04:42AM
832
November 29, 2015 11:25AM
881
November 30, 2015 01:24AM
864
December 01, 2015 06:14PM
882
December 02, 2015 01:12AM
828
December 07, 2015 01:22AM
808
December 07, 2015 10:24AM
702
December 08, 2015 08:58PM
Re: Chinese data not appraing
803
December 09, 2015 01:04AM


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.