JBossDeveloper

From what I see that should not occur with the 9.1 driver as specified in the pom as the source in the pg v3 ConnectionFactoryImpl explicitly checks for UTF8 and not UNICODE.

Perhaps you're picking up the 9.0 or older driver somewhere in your build.  Are you sure this is a clean build?

If you can, set a breakpoint in the v3 ConnectionFactoryImpl - http://grepcode.com/file/repo1.maven.org/maven2/postgresql/postgresql/9.1-901-1.jdbc4/org/postgresql/core/v3/ConnectionFactoryImpl.java?av=f

Notice that it not only requests UTF8 at startup, but that it also ensures that the server responds with UTF8.  No where on the server side since 7.7.x do set the encoding to UNICODE.

You could also post the surefire .xml to see if there is perhaps a system property that is influencing the pg driver.

Steve

I missed a notification for your previous posting, but as expected just modifying the system properties have no affect.  With the expected pg driver and the Teiid code neither making references to setting the client_encoding to UNICODE, I can't really guess at what as going on other than a different pg driver is being used on your system.

You can debug or you can add:

URL location = Driver.class.getResource('/'+Driver.class.getName().replace('.', '/')+".class");

System.out.println(location);

into the failing test to print out the jar being used.  Mine reports the expected maven jar:

jar:file:/home/shawkins/dm-3/shawkins/.m2/repository/postgresql/postgresql/9.1-901.jdbc4/postgresql-9.1-901.jdbc4.jar!/org/postgresql/Driver.class

Debugging the driver/server will be the only way to track this down then.  Neither their source nor ours specifies the encoding should be UNICODE, so it's not clear at all where the conversion of UTF8 to the UNICODE name is happening.  Given that they are equivalent to pg I am not overly concerned, but it would be good to know why there is a platform variation.

See the ODBCServerRemoteImpl get/setEncoding methods for the primary control points where we handle the encoding.

Steve