CHAR vs VARCHAR ,latin1and uft8 issues
Posted by: Michal Deks
Date: February 13, 2009 09:20AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
CHAR vs VARCHAR ,latin1and uft8 issues
5174
February 13, 2009 09:20AM


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.