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.

Options: ReplyQuote

Written By
Re: Is STR_TO_DATE function doesn't work with UCS2 charset?
March 05, 2013 11:17PM

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.