MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

Re: Is STR_TO_DATE function doesn't work with UCS2 charset?
Posted by: Rick James
Date: February 20, 2013 05:05PM

There is rarely a valid reason for using any character set (on a database/table/column) other than ascii, latin1, utf8, or utf8mb4. The character set in the client does not need to be the same; conversions are done as you INSERT / SELECT.

What was the reason for picking usc2?

More on CHARACTER SET and COLLATION:
http://mysql.rjweb.org/doc.php/charcoll

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Is STR_TO_DATE function doesn't work with UCS2 charset?
3800
Jagadish Talluri
February 15, 2013 12:58AM
Re: Is STR_TO_DATE function doesn't work with UCS2 charset?
2184
Rick James
February 20, 2013 05:05PM
Re: Is STR_TO_DATE function doesn't work with UCS2 charset?
2037
Jagadish Talluri
March 04, 2013 08:32AM
Re: Is STR_TO_DATE function doesn't work with UCS2 charset?
1986
Rick James
March 05, 2013 11:17PM
Re: Is STR_TO_DATE function doesn't work with UCS2 charset?
1863
Jagadish Talluri
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.