Srini Chavali wrote:I will try to explain in english, sorry for the language errors.
How so ?
orafad wrote:Ok for new applications or uses, but a serious company would offer a compatibility option for your costumers (even for a free product).
I think this is nothing new or specific to XE. Edition regardless, Oracle has recommended Unicode for database character set since 11.1 (or even 10.2).
Its in the docs. Examples:
+"At the top of the list of character sets Oracle recommends for all new system deployment is the Unicode character set AL32UTF8."+
+"Oracle recommends Unicode AL32UTF8 as the database character set. Unicode is the universal character set that supports most of the currently spoken languages of the world. It also supports many historical scripts (alphabets). Unicode is the native encoding of many technologies, including Java, XML, XHTML, ECMAScript, LDAP. Unicode is ideally suited for databases supporting the Internet and the global economy."+
Etore Schiavini wrote:Well, the docs for GA release of XE 11g hopefully will have something on migration (including this certainly expected issue), i.e a chapter on user data migration.
SQL> insert into t values( 'abç' )
insert into t values( 'abç' )
ERROR at line 1:
ORA-12899: value too large for column "SCH"."T"."C" (actual: 4, maximum: 3)