Post reply

ASCII sql server

  • September 24, 2019 at 9:07 pm

    #3683103

    Hello,i new here,i not know if this topic is in correct place,please if not..move for me thanks

    My question is :

    How block ASCII in sql server ?( exponential numbers)

    thanks

  • September 24, 2019 at 9:20 pm

    #3683107

    What do you mean when you say "but still people can login using exponential numbers"?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • September 25, 2019 at 1:25 am

    #3683155

    I want to block exponential numbers in sql, how can i do this?

  • September 25, 2019 at 2:22 am

    #3683163

    larimin55 wrote:

    I want to block exponential numbers in sql, how can i do this?

     

    I don't know because I don't know what you mean by "exponential numbers" nor what such numbers have to do with "ASCII".  The ASCII character set doesn't have "exponential numbers" nor where you're getting them from, etc, etc.  Are you simply talking about numbers that appear in the form of nnnnExxx?  If so, what do you mean by "blocking them"?  Are you receiving data in that form and you want to reject rows with such values or convert them to something else or what?  And are they actually numbers that you're dealing with or strings of characters that look like numbers?

    Keep in mind that you know what your talking about but we don't.  You have to be a bit more clear.  Some examples of what you're talking about would help us help you.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • September 25, 2019 at 5:23 pm

    #3683385

    hello,how i can change collation of db ,or table ?

    thanks

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply