SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot
    Join Date
    Jan 2013
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Insert database problem

    Hello guys, i wanted to ask is it possible to insert a very very long integer inside mysql? Below is the data that i wanted to insert into mysql:

    f5 00 00 00 29 05 15 52 41 07 a3 d4 21 0d b6 19 61 10 31 40 81 17 12 e8 c1 19 b1 99 21 1a a1 29 c1 29 32 da e1 2a 91 d1 e1 2e 08 e7 21 2f 35 43 61 32 94 27 c1 3a 99 93 21 3c a8 16 01 3e af c2 41 3f bd 87 61 4b 2b 19 c1 50 89 24 61 54 a7 1a 41 59 22 26 21 5a a9 5f a1 5c 25 e5 61 62 a5 e4 61 65 35 21 21 6f 2d e3 01 7b 1d 29 21 13 1b e9 a2 17 15 52 42 1c 99 53 22 1d 09 51 e2 2b a8 d5 62 39 0c 90 82 40 36 5d 82 47 9b e7 62 56 13 8e c2 57 99 50 c2 62 aa 21 c2 65 0c e3 22 6a 91 20 82 79 95 d5 02 7f 94 c7 62 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 27 f5

  2. #2
    SitePoint Mentor bronze trophy
    John_Betong's Avatar
    Join Date
    Aug 2005
    Location
    City of Angels
    Posts
    1,580
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Why not store it as a string and convert the retrieved string when it is required?

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,021
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by Marvin_G View Post
    Hello guys, i wanted to ask is it possible to insert a very very long integer inside mysql?
    to start with, that's not an integer, so for that string, no

    UNSIGNED BIGINT will accept integers up to 18 quintillion and change
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •