MySQL Forums
Forum List  »  General

Convert string into a number
Posted by: Geoffrey Brier
Date: October 17, 2010 03:36PM

Hello everyone ^^
I would like to know if it was possible to convert a string into a sequence of numbers ONLY using mathematical functions? If it's the case, could you show me some examples?
For instance :
query : select operation('abc')
result : 010203 (it's not the real numbers, just an example)

I have tried conv(hex('string'),16,10) but it seems it causes an overflow with long strings, so it does not work properly ...

Another question, is there any way to divide a string only using mathematical functions?

Thanks in advance,

Options: ReplyQuote

Written By
Convert string into a number
October 17, 2010 03:36PM
October 17, 2010 11:18PM
October 18, 2010 07:16PM

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.