MySQL Forums :: General :: Convert string into a number


Advanced Search

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,
Geoffrey

Options: ReplyQuote


Subject Written By Posted
Convert string into a number Geoffrey Brier 10/17/2010 03:36PM
Re: Convert string into a number Chad Bourque 10/17/2010 04:23PM
Re: Convert string into a number Rick James 10/17/2010 11:18PM
Re: Convert string into a number Geoffrey Brier 10/18/2010 01:56AM
Re: Convert string into a number Rick James 10/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.