MySQL Forums
Forum List  »  Newbie

Re: Is STR_TO_DATE function doesn't work with UCS2 charset?
Posted by: Rick James
Date: March 04, 2013 09:44AM

Your queries demonstrate that a VARCHAR in latin1 or ucs2 can be correctly converted to utf8 or latin1 in the client.

And it demonstrates that the server-side function STR_TO_DATE() works with latin1, but not with ucs2.

Try this:
SELECT str_to_date(CONVERT(my_date USING latin1),'%m/%d/%Y %H:%i:%s') from char_set_testx;
That should convert your ucs2-encoded bytes to latin1-encoded bytes, at which point, str_to_date() will be happier.
Those steps happen in the server, before the parameters in SHOW VARIABLES LIKE 'char%' get involved.

Options: ReplyQuote

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.