character issue

[krishdw85]

Team,

Can you please check attachement and guide the character issue. I see data diff while i run in cognos & database.

[krishdw85]

Just a small update. Below issue happens only when we are using Unix ODBC connection and happens in all the formats (XLS/HTML and PDF).

Everything comes fine if we use the Native connection but we can't use the Sybase native connection due to certain limitation

[MFGF]

Just a small update. Below issue happens only when we are using Unix ODBC connection and happens in all the formats (XLS/HTML and PDF).

Everything comes fine if we use the Native connection but we can't use the Sybase native connection due to certain limitation

Does the ODBC driver you are using support UTF8? I'm guessing not, and this is the reason for the issue you are seeing. Are there any other ODBC drivers you can use that support UTF8?

MF.

[krishdw85]

Thanks MF , first of all appreciate for your help for many of my queries!!

Can we force it to be UTF8 in unix, if yes kindly help me with the procedure. Or else is there any way that we can make it support by copying any files etc....??

Thanks,
Sai

[MFGF]

Thanks MF , first of all appreciate for your help for many of my queries!!

Can we force it to be UTF8 in unix, if yes kindly help me with the procedure. Or else is there any way that we can make it support by copying any files etc....??

Thanks,
Sai

Sadly that's a question I can't answer - I don't have skills in the workings of ODBC drivers on unix, sorry. Where did you get your current driver from? Can the provider of the driver help? Are there alternative drivers that are UTF8 compliant if you do a web search?

Cheers!

MF.

[bdbits]

One of my favorite sites for finding ODBC options: https://www.connectionstrings.com/

I am not sure how you do this in Unix, but I think you need to add this to the connection string: Charset=utf8