We have written an application using JSP/Servlets on an apache webserver with an MS SQL database. We are using the JdbcOdbcDriver from Sun, because the MS SQL Jdbc driver caused to much troubles.

This was running fine in the developmen/test environment, but now we have done a first pilot in production. What we see there is that all diacritics (, , , etc) are replaced by a ? (question mark). When we look in the database tables we see the original characters, so my best guess is that somewhere between the database and the servlet there is some replacement going on.

Because this connection is controlled by the jdbc driver I would guess that it has something to do with the driver.

Can anybody help me with this?