Friday, October 26, 2007

Oracle DB User and Password with Turkish Characters

If you have ever put turkish characters in your username and/or password for your DB and tried to use it thru an application, you might have gotten:

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

This is due to the fact that oracle JDBC driver does a local insensetive upper case and therefore the turkish characters gets converted incorrectly.

For example, if your username had 'kaşmir' this should be converted to 'KASMIR' but gets converted to 'KAŞMİR' and therefore not supported.

No comments: