| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> just infnore him
<0> *ignore
<0> ill brb looking on google about cast useage seems to be the soloution
<1> I dunno what the datatypes are in mssql
<2> virgin29 something you seem to know nothing about
<3> ***yIce, you are so new
<4> scatterp: tinyint is unsigned in mssql
<1> in DB2 all numbers have sign
<2> maybe i am in this but not in other things we all have to learn
<4> i dont get the signifigance of signed or not.. i get it, but i dont understand the purpose
<0> oh
<5> Cuts the maximum value in half, allows the value to be negative.
<4> ah interesting
<3> it is so bad t-sql has no unsigned int
<0> phargle we have a tool that converts some atributes to a unsigned int and a application that converts and saves to a database as a signed int to correlate between them we need to i believe CAST AS or CAST TO
<4> if you dont mind me asking, what would -2473 convert to unsigned?
<0> err let me see
<3> Darken|, are you in VA?
<4> ohh, i kinda get it
<0> just a sec ill have the number in a moment
<0> 4294964823
<0> is -2473
<0> so asumeing you had a database with -2473 in it
<0> i want to display it as
<0> 4294964823
<0> i think i got to use cast not fully sure how yet
<3> use numeric(18,2)
<3> damn
<3> i mean, numeric(18,0)
<0> hey for anyone here who mentioned cast i have managed to find out how to use the command but i am unsure on the correct datatype to make the destination
<0> mysql seems to support appropriate data types but i just dont see it in mssql
<0> :/
<6> scatterp what are you trying to do
<0> Darken| i need to cast from an signed int to an unsigned int
<6> this is outside of sql?
<0> no inside sql (mssql)
<6> what destination is going to be interpreting it as an unsigned bit
<5> Casting would be easy, storage would be the problem.
<6> since ms sql doesn't use unsigned datatypes
<6> not really
<0> well basicly i got a colunm full of numbers (signed)
<5> Depends on what he wants to do.
<6> i know what you have scatterp
<6> just answer my question please
<0> if i convert them to unsigned (or if i could)
<6> otherwise i can't answer yours
<0> Darken| sorry im trying as best as i can
<6> ok
<6> go on
<5> Explain the problem, not the solution.
<0> i have also a exe that converts from plain english to these unsigned numbers
<6> plain english
<6> as in 7bit ASCII?
<0> for example the data base is for a game
<6> what language is your program written in scatterp
<5> oh boy
<0> lets say your a player and you have a sword (its agile gives you +105 hit probibility)
<0> the agile + 105 hit probibility is this number
<7> this ****ed
<0> i need to see that as text
<0> in the sql database
<7> i created Atomic thingies
<6> scatterp the original source is coming from the database?
<7> to track instances
<5> Explains why he can't explain it terribly well.
<7> but the problem is, it's not global
<7> it's per instance
<6> scatterp why not have sql convert the number to text for you
<7> so GlobalAtom is not really global
<6> OR, convert the number directly to text yourself?
<0> Darken| yes from the database
<7> cast(mynum as varchar)?
<6> convert it to varchar
<0> Darken| have the sql convert the numbers to text is what i am trying to achieve
<6> scatterp check what quant said
<5> Why have the SQL do it?
<5> Why can't the program do it?
<6> Halo_Four for the sake that it is easier
<6> and maybe scatterp doesn't know how
<5> It's still formatting at the server.
<0> Darken| if i convert them to unsigned numbers thats 1 step in the right direction since i have a (text to unsigned.exe)
<7> what
<6> scatterp how about delete your "text to unsigned.exe"
<7> he's pulling yall leg
<6> i'll make this simple scatterp
<0> Quant sql doesnt understand how to cast it as varchar
<6> i don't know if i believe that
<6> there has to be a way
<0> wait wait look slow down im useless at explaining things how about if ***yIce explains she does much better than me
<0> at explaining
<5> Games programming is of the most difficult and tedious programming. It's not fun. It's not a good place for an aspiring programming to start. It's also not a really good career aspiration due to the low demand in the field.
<5> s/programming/programmer
<6> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp
<6> ms-sql most certainly can convert an integer to varchar
<6> Halo_Four
<0> oh yes Darken| i know that
<6> there is a demand for game programmers
<5> I don't see any need for unsigned types at this point.
<5> Darken: Not really.
<6> for hard working (60+ hours) a week
<0> Darken| but what if theres a look up table that converts each number to a word and msql dont have the table ..
<6> scatterp ok uhm
<6> what you want is a programming question
<0> Darken| listen to ***y she can explain much better
<6> i can help you with the routine, but it is outside the scope of SQL
<6> understand?
<5> scatterp: If you're looking to convert 1 to "one" then you're going to have to write a ****load of code.
<2> ok let me try and explain we have an sql database and in one of the table there is a list of numbers that are signed int now we dont understand the signed int we can only understand the unsigned int
<5> Actually it's not a ****load, but it's not fun, it's formatting and it's outside of the scope of this channel.
<6> ***yIce do you actually use negative numbers?
<0> Halo_Four no im looking to convert 4294964823 to "rightchous +15 +105 hitpoints "
<2> so what we need to do is convert the signed int to unsigned so we know whats in that table
<6> you guys lack a core understanding of how the bits in datatypes work
<6> this is confusing you the most right now
<0> yes true
<2> some are negative some are not
<5> Don't store crap in a composite manner as such
<6> ***yIce if you have -107, what do you intend to do with it
<6> display it as "-107" in text on their screen?
<5> 4294964823 shouldn't relate to "rightchous +15 +105 hitpoints "
<2> we need to make it into the real number it was before the database converted it to signed int
<2> this way we know what it is
<0> Halo_Four it does i have a calculater that you input the words and it gives you that number and then if you look in the data base you see it as a signed int i have another calculater that goes between them
<6> scatterp first off
<4> i'd hardwire the calculator to the app
<6> your calculator is probably crap
<6> if you're using this for a game, delete your 3rd party calculator
<6> it's not efficient enough
<0> thats why we want the sql to do it Darken|
<5> The SQL shouldn't do it
<6> also
<6> no scatterp
<6> sql should not do it if it is for a game
<0> Darken| and the calulater only works one direction (the wrong one)
<6> that would be far too expensive
<5> Hire a programmer, seriously.
<6> what language is this scatterp?
<0> c++ i got a programer he wrote one of the calculators
<2> ok
<0> its a matter of auditing the databases contents that we need to do this btw
<2> in the game you can only use unsigned int
<5> Split the data into separate fields. Don't bit-bash it into a single composite field.
<2> to make an item
<6> scatterp store it as unsigned in the database
<2> but as this is put to the database
<6> and do the conversion in your c++ application
<6> it is VERY simple
<2> it changes it to signed
<5> cast it
Return to
#sql
or
Go to some related
logs:
#computers
#windows
#beginner
windows set default power management
regsvr 0x80040200
#windows
#linux-noob
#computers
sexygrrl1
funny saturda quotes
|
|