cedricgodfroy,

I used to have the same problem. Are u reading from text files using a tFileInputdelimited component?
If so you need to change the decoding in the component in the advanced settings. This should fix it.


Kind regards

Check input character coding page. And try to convert it, best to utf-8.

On the other hand if you are talking about just 2 characters, you can try following:
Unicode
Codepos.    Character    UTF-8(hex.)    Name
U+00E9    é             c3 a9            LATIN SMALL LETTER E WITH ACUTE
U+00EF    ï             c3 af            LATIN SMALL LETTER I WITH DIAERESIS

You could initiate your special character with one of the following statement (any of these will work) in tJavaRow:
String sU00E9 = "\u00E9";
char cU00E9 = '\u00E9';
Character CU00E9 = new Character('\u00E9');

And then you could try replace occurences of the char in output stream to tMSSqlOutput.

I also faced these issues as soon as I am Czech, so we have also some special characters against simple english character map.

Let me know.

Ladislav

Hi

I am trying to insert data in a SQL Server DB. I am using a file delimited. When test with msgbox, output file everything is OK.
The DB connection is working the table in DB is created and when inserting there´s no error and nothing inserted in DB.

Someone can help me please.

Thanks in advance.