Re: Latin -> UTF-8 - All or Some?
Posted by: Alexander Barkov
Date: December 01, 2006 04:26AM

What column types do you use?

CHAR() is fixed length type, and if you declare a column of "CHAR(7) CHARACTER SET UTF8",
it will use 21 byte in each record.

VARCHAR() is variabke length type. IF you insert "joeuser" into a VARCHAR,
it will use only 7 bytes - the actual data size.

It's ok to go #1 using VARCHAR for all columns.

If you need CHAR() for some reasons, then it's better to go #2 to get smallest database size.

Options: ReplyQuote


Subject
Views
Written By
Posted
3875
dbv
November 29, 2006 02:02PM
Re: Latin -> UTF-8 - All or Some?
1967
December 01, 2006 04:26AM
1991
dbv
December 01, 2006 11:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.