Re: bcp -Jutf8 conversion fails

On Feb 25, 4:31 pm, "ThanksButNo" <no.no.tha...@xxxxxxxxx> wrote:
Ok, I've read the instructions. Honest.

I try (as per instructions),

bcp database.dbo.table out tableFile -c -Usa -P -Jutf8

And the error message is:

Server Message: {hostname} - Msg 2401, Level 11, State 2:
Character set conversion is not available between client character set
'utf8' and server character set 'iso_1'.

Server Message: {hostname} - Msg 2411, Level 10, State 1:
No conversions will be done.

Sybase 12.5.1 on Solaris 8.

Ok, the "locales.dat" file is where it's supposed to be. I funged
around with the "LANG" and "LC_ALL" environment variables, setting
them to things like empty, "C", "en_US", "us_english", etc. Nothing
helps, and some things not only don't help, but also cause Solaris to
complain (such as setting it to "us_english.utf8").

So what am I missing?

Did you try just completing unsetting the internationalization vars,
e.g.: unset LC_ALL
???

Keith

.