MySQL Forums
Forum List  »  Newbie

Re: How to convert function substrb from oracle to mysql
Posted by: Khanh asdasda
Date: June 19, 2017 09:42PM

i used it but it 's not same.
example
MYSQL
select substr("Trần",1,4);
Result: Trần
In Oralce use substrb
select substrb("Trần",1,4) from dual
Result:Tr

because Oracle read char "ầ" is 3 bytes.

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.