Character set conversion and database size

From: Schauss, Peter (ESS) <"Schauss,>
Date: Fri, 14 Aug 2015 19:08:44 +0000
Message-ID: <8b9943ba88c44b25aa35c13330b51a39_at_XCGVAG22.northgrum.com>



Oracle 12.1.0.2 on Red Hat Linux.

IT management is pushing us to migrate our databases to the Unicode character set ( NLS_CHARACTERSET= WE8MSWIN1252 to AL32UTF8). One of my internal customers is concerned that conversion to multibyte characters will dramatically increase the size of the database. I know that for VARCHAR2s Oracle only allocates storage for the actual characters stored in the string regardless maximum defined size of the column. Does the same idea apply a VARCHAR2 column whose contents can be coded as single bytes or does "Hello world!" actually take twice as much space in Unicode as it does in the default character set?

Thanks,
Peter

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 14 2015 - 21:08:44 CEST

Original text of this message