Results 1 to 14 of 14
Thread: FIREBIRD
Hybrid View
-
11th July 2011 10:48 #1
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.
-
11th July 2011 13:50 #2
-
11th July 2011 14:19 #3Registered User
Join Date: Aug:2006
Location:
Posts: 4,052
, float/double .
63.99999999997 .
-
11th July 2011 15:00 #4
-
11th July 2011 17:09 #5Registered User
Join Date: Aug:2006
Location:
Posts: 4,052
.
, account- - , .
float float , - ( ).
( -, ..)
ps: - 3D. blazing , sacrifice- .
-
11th July 2011 15:10 #6
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_USDLast edited by finalista; 11th July 2011 at 15:32.
-
11th July 2011 15:40 #7
-
11th July 2011 15:43 #8
, , , , .
, .
, BGN, EUR USD , () ..
: PRICE_BGN, PRICE_EUR PRICE_USD, .
, PRICE CURRENCY, ..Last edited by finalista; 11th July 2011 at 16:21.
-
11th July 2011 16:46 #9
, , . , . , redundancy, , ..
, .
- . , , , ( ..). .
-
11th July 2011 17:02 #10
-
11th July 2011 19:13 #11
.
, , . , ( ) "" .
, , , . .
, , , , . PHP, " " , .. . , , , .
, , . , , - .
-
11th July 2011 19:56 #12
....
MATERIALS, , CHARSET WIN1251.
Zeos Access - TZQuery ????? .
CharSet TZConnection WIN1251.Last edited by finalista; 11th July 2011 at 20:12.
-
11th July 2011 23:33 #13
, cp1251 , SET NAMES 'CP1251' . .
, .
win1251?
mysql- , UTF-8 .
-
12th July 2011 00:06 #14
UTF8.
CharSet WIN1251 UTF8.
:
!Code:ZConnection.Properties.Text := 'Codepage=UTF8';




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in