Re: Is STR_TO_DATE function doesn't work with UCS2 charset?
Posted by:
Rick James
Date: March 05, 2013 11:17PM
> The DBA team mentioned that it was choosen to support european character sets.
Your DBA team needs to learn about CHARACTER SETs. ucs2, while it does support European character sets, it is not optimal. Yes it is (I think) the internal encoding in Java; they may be the last user of ucs2.
Another reason to avoid it for Europe... ALL characters take 2 bytes. With latin% ALL characters take 1 byte. (However, not all character sets in Europe can be handled by just latin1 or just latin7, etc.) With utf8, most European characters are the same as English and take 1 byte. The rest take 2, including accents in Western Europe, Greek, and most eastern European character sets.
That is, European text is bigger in ucs2.
See your other thread.
Subject
Views
Written By
Posted
3782
February 15, 2013 12:58AM
2171
February 20, 2013 05:05PM
2026
March 04, 2013 08:32AM
Re: Is STR_TO_DATE function doesn't work with UCS2 charset?
1969
March 05, 2013 11:17PM
1847
March 22, 2013 08:15AM
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.