Is STR_TO_DATE function doesn't work with UCS2 charset?
Dear All,
Pleaes help me with this quick query.
[Server version: 5.5.29-log MySQL Community Server (GPL)]
I am working with a table which is having default charset ucs2. One of the coloumn is varchar(64) contains datetime information.
I need to convert that varchar column to datetime in order to do some business logic. I used STR_TO_DATE function, It didn't work.
I got a NULL, with a warning code 1411 and message - Incorrect datetime value: '' for function str_to_date.
I did a quick experiment, changed the column charset to latin1. It's working.
My query is, does the function STR_TO_DATE is incompatible with ucs2 charset?
Is there any documentation available which mention about this incompatibility with certian set of charsets?(I serched this entire week and didn't find one, help me if you find one)
For some function like char_length() are mentioned as multi-byte safe.
Therefore, do I need to consider, the functions which are not mentioned the same way are incompatible with multi-byte?
Kindly help.
Subject
Views
Written By
Posted
Is STR_TO_DATE function doesn't work with UCS2 charset?
3802
February 15, 2013 12:58AM
2185
February 20, 2013 05:05PM
2037
March 04, 2013 08:32AM
1986
March 05, 2013 11:17PM
1863
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.