Allow specific characters for columns in schema s doesn't work

[Anonymous]

Hi,

Before upgrading to Talend 6.5.1 on LINUX, i was working with Talend 4.1.2 on Windows and i had no problems with column names containing $ (in an ORACLE database). When i retrieved or updated metadata, $ was not replaced by an _ :

Here is an example with $ in column and DB column

Now in Talend 6.5.1 :

Now DB column contains $ but column contain _The allow specific characters for columns of schemas is enabled

Why special character $ is replaced by _. Is it due to charset ?

Thank you for help

[Anonymous]

Hello,

Since Talend don't support the special characters like  "$" in the column name, it will replace automatically "$" with "_" when retrieving schema. Have you tried to generate the 1st line with a tFixedFlowInput and complete your file without column titles?

Best regards

Sabrina

[Anonymous]

Hello,

My problem is that all my projects (about 100/200 jobs) includes tOracleInput with schema where the "$" was not replaced (in column name and DB column name) by an "_" because it was supported. Now, each time i update a database schema, i have to modify each job that uses this schema because in the first tMap coming after the tOracleInput, the input and output columns are not connected anymore.

best regard

[Anonymous]

Hello,

The "Allow specifc characters" option  is mostly used to allow at least like chinese or japanese characters.

Are you using talend open studio V 6.5?

Best regards

Sabrina

[Anonymous]

Hi,

Yes i'm using TOS for DI 6.5.1

Best regard

Yannick

[Anonymous]

Hello,

We will make an investigation on your issue to see if there is a workaround and then come back to you as soon as we can.

Best regards

Sabrina