Why does Oracle accept non-ASCII characters even if DB charset is US7ASCII?

From: Jesus $John$ Salvo Jr. <john_at_softgame.com.au>
Date: Wed, 05 Dec 2001 23:43:30 GMT
Message-ID: <CiyP7.417860$bY5.1758684@news-server.bigpond.net.au>

Why doesn't throw an ORA error saying that the character being inserted / updated is beyond the character set of the database? For example, I you can actually insert into a varchar2 column the acute e character ( 130, which is beyond the 128, 7-bit ASCII ), and Oracle does not complain.

This makes it a pain when converting from one DB charset to another, even to UTF8 ... because UTF8 expects a different encoding ( not 130 ) for acute e. Received on Wed Dec 05 2001 - 17:43:30 CST