One Star

Character Varying[]

I am attempting to insert rows into a Postgres table that has a column defined as a character varying array. I am trying to use a tMap component but there does not seem to be a suitable data type to map to a column of this type. I have tried using a tJavaRow and built a java String[] and that didn't work either.
I have searched extensively and have found no information regarding this. Has anyone successfully done this before?
Thanks in advance,
T
4 REPLIES
One Star

Re: Character Varying[]

Hi ,
Use "String" data type for character varying.
Thanks,
Kumar
One Star

Re: Character Varying[]

It is a character varying array though not a simple character varying field.
{"This ,"Is", "the","data"} not 
"This is the data"
Seventeen Stars

Re: Character Varying[]

hi,
try to add varchar[] in window -> preferences -> talend -> specific setting -> metadata of talend type 
drom java type to db type & db type to java type for  varchar [].(i've done it for json type for postgres without problem)
but still the way to propagate String[] type in Talend flow ... no idea right now !
regards
laurent
Seventeen Stars

Re: Character Varying[]

.... perhaps using list type to propagate data & list.toArray before insert in DB ....