Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » How to setup Charset in Access Connection

#1 2012-07-20 15:58:54

plepoupon
Member
Registered: 2012-07-17
Posts: 11

How to setup Charset in Access Connection

Hi everyone !

I'm trying to send some informations from a Dutch database with containt specials char like ä in the SalesForce cloud.
But all my specials chars arrived like '?'.
As I sow on the trace window the output from Access isn't correct as I get the '?' for all specials chars, I was looking for some encoding option on the compoment but did'nt find nothing.
Can anybody help me with this ?..
thanks !

Last edited by plepoupon (2012-07-23 17:37:44)

Offline

#2 2012-07-20 16:58:36

plepoupon
Member
Registered: 2012-07-17
Posts: 11

Re: How to setup Charset in Access Connection

I forgot to mention that the databases is MS Access.

Offline

#3 2012-07-20 17:37:32

janhess
Member
Company: Newcastle University
Registered: 2009-05-19
Posts: 1121

Re: How to setup Charset in Access Connection

Have you checked the character set you are using on the components.

Offline

#4 2012-07-23 09:31:08

plepoupon
Member
Registered: 2012-07-17
Posts: 11

Re: How to setup Charset in Access Connection

I use the tAccessInput component and I dont have any Character Set option available ..?

Offline

#5 2012-07-23 17:23:08

plepoupon
Member
Registered: 2012-07-17
Posts: 11

Re: How to setup Charset in Access Connection

I cannot find any Options on Talend to specify the Charset or Character Set.
Can anybody know where I can find it, should I need to write something in java for this ?
Thx a lot for helping, regards;
Philippe.

Offline

#6 2012-07-24 09:10:14

plepoupon
Member
Registered: 2012-07-17
Posts: 11

Re: How to setup Charset in Access Connection

Hi
This post http://www.talendforge.org/forum/viewto … ?pid=25797 from 2010 seen to refere to the same problem
So there is no issue on that point, should I add a bug ?

Offline

#7 2012-07-24 09:24:50

Asad
New member
Registered: 2012-07-11
Posts: 1

Re: How to setup Charset in Access Connection

I am getting the below error. I am using the windows 7 and in my laptop i am having 4 GB RAM. Please find the screen shot of the error

An internal error occurred during: "Generation Engine Initialization in progress...".
java.lang.NullPointerException

Offline

#8 2012-07-24 10:47:45

plepoupon
Member
Registered: 2012-07-17
Posts: 11

Re: How to setup Charset in Access Connection

I did two tests : First duplicate the dbImput code in a Tjava component and force the ISO-8859-15 encoding in the connection : Returns caracters was Good (no more '?' accent and special char are OK!).
So I went to XML property files of dbImput and activate the Encoding Var (it was hidden)
I put ISO-8859-15 (that's was default option, but just in case...) ... No change, seens that this Var is not consider by Talend... That should be a bug ?! Right ?

Offline

#9 2012-07-24 14:10:17

cocofoto
New member
Registered: 2012-07-24
Posts: 1

Re: How to setup Charset in Access Connection

Hi!
I face exactly the same problem.
I load data from a SalesForce like db and put it in a SQL Server, using dbInput component. Special characters are displayed as "?" in SQL server. Can't figure out where to set the character type in Talend.

I should mention everything was working fine a few days ago, until I update my Talend version from 4 to 5...

Thanks for your help!

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » How to setup Charset in Access Connection

Board footer

Powered by FluxBB