We have two Oracle 10i database, one in Windows (NLS_CHARACTERSET=WE8MSWIN1252) and one in Linux (NLS_CHARACTERSET=AL32UTF8). The difference is that WE8MSWIN1252 is 1 byte per character, and AL32UTF8 reserves 4 bytes per character. Both databases have the same schema and structure. The "Columns" view in SquirrelSQL shows VARCHAR2 columns on the Linux database as being four times larger than the same columns on the Windows database. I believe it is showing the column size as the total number of bytes, rather than the total number of characters. There seems to be no way to see the total number of characters, except to remember always to mentally divide by four when viewing the Linux database.