Wednesday, January 19, 2005

Are you sure your Oracle is set to UTF8?

SQL Error: 17037, SQLState: null
java.sql.SQLException: Fail to convert between UTF8 and UCS2:  failUTF8Conv

I googled, googled... Found plenty of people asking the same question, but no definite answer.

The problem turns out to be that the correct NLS_LANG setting for UTF-8 support is AL32UTF8, not UTF8. As documented in Oracle's Globalization Support Guide, only AL32UTF8 supports the Unicode 3.1.

Technorati Tags: ,

No comments: