Results 1 to 14 of 14

Thread: FIREBIRD

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Android C3P0 finalista's Avatar
    Join Date: Jul:2009
    Location:
    Posts: 948

    FIREBIRD

    FIREBIRD : DOUBLE PRECISION DECIMAL ?
    :
    DOUBLE PRECISION 8 bytes 1.7 * 10-308 to 1.7 * 10308 - 15 digits of precision (Note: The size is actually platform dependent.);

    FLOAT 4 bytes 3.4 * 10-38 to 3.4 * 1038 - 7 digits of precision;

    NUMERIC(precision, scale) variable Used to hold exact numbers precision (1 to 15) specifies how many digits to store. scale (1 to 15) (when present) specifies location of decimal point. Must be less than or equal to precision. Example - NUMERIC(10,3) - ppppppp.sss - stores exactly 10 digits;

    DECIMAL(precision, scale) variable Specifies the minimum precision desired, but more is ok precision (1 to 15) specifies the minimum number of digits to store. scale (1 to 15) (when present) specifies location of decimal point. Must be less than or equal to precision. Example DECIMAL(10,3) - ppppppp.sss - stores at least 10 digits.

  2. #2
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    DECIMAL, / , precision.
    Float, .

  3. #3
    Registered User
    Join Date: Aug:2006
    Location:
    Posts: 4,052
    , float/double .

    63.99999999997 .

  4. #4
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    Quote Originally Posted by solar_sea View Post
    , float/double .

    63.99999999997 .
    . , decimal .
    PHP decimal native type?!
    , - integers / .. .

  5. #5
    Registered User
    Join Date: Aug:2006
    Location:
    Posts: 4,052
    .

    , account- - , .

    float float , - ( ).

    ( -, ..)

    ps: - 3D. blazing , sacrifice- .

  6. #6
    Android C3P0 finalista's Avatar
    Join Date: Jul:2009
    Location:
    Posts: 948
    EUR USD, , .
    , :
    PRICE_BGN........DECIMAL........16...... ..4........Not null ( 0.01 )
    PRICE_BGN........DECIMAL........16...... ..3........Not null ( 0.1 )
    PRICE_BGN........DECIMAL........16...... ..2........Not null ( 1. )
    :
    1 EUR = 1.955830 BGN
    1 USD = 1.373280 BGN
    PRICE_BGN 1.955830 PRICE_EUR
    PRICE_BGN 1.373280 PRICE_USD
    Last edited by finalista; 11th July 2011 at 15:32.

  7. #7
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , ? ?
    , /, float, .. .

  8. #8
    Android C3P0 finalista's Avatar
    Join Date: Jul:2009
    Location:
    Posts: 948
    , , , , .
    , .
    , BGN, EUR USD , () ..
    : PRICE_BGN, PRICE_EUR PRICE_USD, .
    , PRICE CURRENCY, ..
    Last edited by finalista; 11th July 2011 at 16:21.

  9. #9
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , , . , . , redundancy, , ..
    , .
    - . , , , ( ..). .

  10. #10
    Android C3P0 finalista's Avatar
    Join Date: Jul:2009
    Location:
    Posts: 948
    Quote Originally Posted by tedych View Post
    , , . , . , redundancy, , ..
    , .
    - . , , , ( ..). .
    !
    .
    , .
    Lazarus Firebird.

  11. #11
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    .
    , , . , ( ) "" .
    , , , . .
    , , , , . PHP, " " , .. . , , , .
    , , . , , - .

  12. #12
    Android C3P0 finalista's Avatar
    Join Date: Jul:2009
    Location:
    Posts: 948
    ....
    MATERIALS, , CHARSET WIN1251.
    Zeos Access - TZQuery ????? .
    CharSet TZConnection WIN1251.
    Last edited by finalista; 11th July 2011 at 20:12.

  13. #13
    Registered User tedych's Avatar
    Join Date: Nov:2003
    Location:
    Posts: 17,654
    , cp1251 , SET NAMES 'CP1251' . .
    , .
    win1251?
    mysql- , UTF-8 .

  14. #14
    Android C3P0 finalista's Avatar
    Join Date: Jul:2009
    Location:
    Posts: 948
    UTF8.
    CharSet WIN1251 UTF8.
    :
    Code:
    ZConnection.Properties.Text := 'Codepage=UTF8';
    !

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |