Re: Chinese data not appraing

[Ra Nala]

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