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.

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

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