topic Re: tMySqlOutput use case in Talend Studio

tMySqlOutput use case

idembel2 — Mon, 07 Aug 2017 18:43:33 GMT

Morning All,

I use tMySqlOutput to creat a new table and insert also records.

My primary Key column is VARCHAR type and everything is OK

But only one problem i get; Talend detect these 2 lines (PK) like the same thing

ANAELLE.GUERIN
ANAËLLE.GUERIN

So i get this error:

tMysqlOutput_1 - Duplicate entry 'ANAËLLE.GUERIN' for key 'PRIMARY'
Duplicate entry 'Céline.PHILIPPON.ERANOVE' for key 'PRIMARY'

I have already try this both collation utf8-general-ci and ut8-unicode-ci but nothing.

Thank you help,

Re: tMySqlOutput use case

TRF — Mon, 07 Aug 2017 22:13:30 GMT

Depending on the character set you have choosen for the database, you may try to create the column using:

yourColumnName varchar(80) collate utf8_bin

Re: tMySqlOutput use case

vapukov — Mon, 07 Aug 2017 23:20:41 GMT

it is not a Talend issue, this is relate to MySQL and it's support of UTF (and error text - not from Talend, but from MySQL)

so, the proper place for search the answer - database related forums

as, example - https://stackoverflow.com/questions/6466901/mysql-distinction-between-e-and-é-e-acute-unique-index

VARCHAR is always not best idea as Primary Key, but

try as suggested use UTF8_bin

https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html

To further illustrate, the following equalities hold in both utf8_general_ci and utf8_unicode_ci (for the effect of this in comparisons or searches, see Section 10.1.8.6, “Examples of the Effect of Collation”):

Ä = A
Ö = O
Ü = U
A difference between the collations is that this is true for utf8_general_ci:

ß = s
Whereas this is true for utf8_unicode_ci, which supports the German DIN-1 ordering (also known as dictionary order):

ß = ss

Re: tMySqlOutput use case

idembel2 — Fri, 11 Aug 2017 15:21:48 GMT

Hello,

Thank all for help, i test it and let you know

Re: tMySqlOutput use case

idembel2 — Tue, 15 Aug 2017 22:20:22 GMT

Hello All,

Thank you very much, Set Column as Utf8_bin solve my problem

Thanks,