problem with encoding euro sign in simple select
2920439Nov 22 2007 — edited Nov 28 2007select '€' from dual;
should fulfill the requirements mentioned in
http://www.oracle.com/technology/products/database/sql_developer/files/relnotes_v121.html#sec4
But the Euro sign is displayed as a result only when connected to a DB with UTF8 encoding. When connected to a SBCS DB with encoding WE8MSWIN1252, ¬ is displayed instead. chr('€') displays 172, which is equal to the last byte of the UTF8 representation of the Euro sign \u20ac = e2 82 ac.
The Euro sign is included in WE8MSWIN1252 with code 128, so I would expect the result of "select '€' from dual " to display correctly in both cases.
I have just downloaded the current version Oracle SQL Developer 1.2.1, java version is 1.6.0_02-b06.