especial caracter

Five Stars

especial caracter

Hi guys,

I hope u re doing well.

I need your help, As mentionned in the screen shoot below, I want to load data into a bulk DB, but I have the especial caracter Ã‰ cannot be loaded and i got error.

 

So, any idea?

Employee

Re: especial caracter

Hi,

 

     Could you please share the following items for further analysis?

 

a) What is the Target DB you are using to load data?

 

b) Could you please verify the encoding is added as UTF-8 in the advanced settings of your Talend component?

 

c)  Could you please try to insert using TDBOutput component and check whether its working? 

 

Warm Regards,

 

Nikhil Thampi

Five Stars

Re: especial caracter

the target DB is slqserver BULK, and the added encoding in the advanced settings of myTalend source component is UTF-8 ,

it still doesn t want work.

Employee

Re: especial caracter

Hi,

 

    Could you please check whether you are able to load data using a tDBOutputComponent? Or try to run an insert statement with this special character. We need to verify whether DB is stopping the data loading due to some language constraints.

 

Warm Regards,

 

Nikhil Thampi

Ten Stars

Re: especial caracter

Basically your telling the database you have a string and is correctly displayed in UTF-8... which means it expects UTF-8.

Lets say your input is in Latin-1 france language setting, if you want to store it in UTF 8 you need to 'convert' an (re)map bytes to it.

Luckily this is done by some string functions... and there's a component tEncoding (I thought)

 

So if you want to do it right, change your DBOutput to the same encoding type as your input, otherwise conversion is needed.

 

 

Five Stars

Re: especial caracter

with tDBOutputComponent, it work correctly, I got problem just with Bulk
component
Ten Stars

Re: especial caracter

... please read this splendid article on encoding ...
http://kunststube.net/encoding/

You will be enlightened.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch