ODBC importer messing with my data

[Maxmix]

Hi,
Just tested ODBC import for the first time.
Everything went OK except all "short I" characters turned into pairs: "cyrillic I" and "?"
This happens soon, already in Preview Data pane and then garbage goes into db table.

I'm not even sure who is culprit?

-Excel 2010 32 bit
-PLSQL Dev: 32 bit 11.0.3
-Db character set : Windows-1251
-Oracle client: Instant 12.1.0.2 but seems it's utilizing -ODBC driver from another 11.2.0.1 home.

Is there something I can do?

Info about small short I character:https://en.wikipedia.org/wiki/Short_I
i.e. E9 is its code in Windows-1251 1-byte encoding.

 

[Marco Kalter]

Are the character sets of the NLS_LANG variable the same for the 12.1 client and the 11.2 client?

 

[Maxmix]

Both homes have
NLS_LANG=American_America.cl8MSWIN1251, yes

 

[Maxmix]

Probably my note about different homes is irrelevant, because I don't access Oracle db via ODBC driver, but rather connect to Excel*32, which hopefully has the only one ODBC driver on my Windows 7.

 

[Maxmix]

Marco, let's make a break. It seems that the character only looks good, but in fact it's bad already in source (Excel cell). At least I cannot copy the cell normally to any non-Unicode application.

 

[Maxmix]

It was 'combining breve' Unicode thing present in the Excel data.
PLSQL Dev works well.

Please consider topic closed.