CHAR vs VARCHAR ,latin1and uft8 issues
I have got following issues:
1. Is it worth to use both latin1 and utf8 in one table (and in database)?
I have database with 57 tables of internet shop. There are many products and I need multilanguage support for database. I use mostly utf8. BUt I figure out that can change some tables into latin1 and some columns into latin1, because i don't need there multinational characters. I know that i could benefit from it with less data stored in database and speed(less data to send).
Could be there some problem with connection with DB like:
- Connection is set to UTF-8, but table is in both utf8 and latin1?
- the same with tables: one table with utf8 other with latin1 connection set ti utf8?
2. I've read that CHAR is generaly faster than VARCHAR, but only if there are only CHARS in one table, non VARCHARS. Is it true?
Subject
Views
Written By
Posted
CHAR vs VARCHAR ,latin1and uft8 issues
5174
February 13, 2009 09:20AM
3933
February 14, 2009 02:18AM
2825
February 19, 2009 10:24AM
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.