MySQL Forums
Forum List  »  Newbie

Re: Is STR_TO_DATE function doesn't work with UCS2 charset?
Posted by: Jagadish Talluri
Date: March 05, 2013 12:26AM

Thanks Rick, for the quick response.

The suggestiong worked well. Therefore, without touching the db structure, I handled this as query level.

Can you please throw some light on multi-byte safe string functions?

Correct me if I am wrong, I believe that multi-byte safe function means, we dont need to bother about the charset of the string argument in function, as that will be taken care automatically as in LEFT(), INSTR() functions.

Since we are using convert() explicitly in the STR_TO_DATE(), can we conclude that STR_TO_DATE is not multi-byte safe?

Kindly help.

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.