How does ODBC works for different language?

I'm trying to uncheck the Perform translation for character data in the System DSN of the ODBC. If I uncheck it, I will get "TESTS FAILED" when I run the Test Data Source. If I check it, I will get "TEST COMPLETED SUCCESSFULLY" when I run the Test Data Source.

If the setting "Perform translation for character data" is unchecked, the returned value for a non-Unicode column using the ODBC System DNS is same as the returned value in Query Analyzer. However, if it is checked, the returned value for a non-Unicode column using the ODBC System DNS is DIFFERENT from the returned value in Query Analyzer.


Thank you for any help.