3.3 Numeric data typesFrom the moment we open our eyes every morning, we deal with numbers almost every hour: from 6:30 on the alarm clock to the 216 bus to work, from the news that the house price fell to 100 yuan per square meter to go home to buy
3.3 Numeric data typesFrom the moment we open our eyes every morning, we deal with numbers almost every hour: from 6:30 on the alarm clock to the 216 bus to work, from the news that the house price fell to 100 yuan per square meter to go home to buy
This section briefly describes five data types in SQL: numeric, text, numeric, logical, and date.
Character Type
Varchar and char
The differences between varchar and char data are subtle, but important. They are used to store strings of less than 255
Before going to bed at night, get this interesting question and try to play with it:============================================================================Rule: "Random floating-point numbers are written according to the RMB reading method"The
Type conversion between basic types (numeric type), type conversion numeric type
As soon as I opened my blog today, I saw the 5-year-old campus in the upper left corner, and my eyes were a bit blank. The scenes of my previous class as a student have
Town Field Poem:The Pure Heart sentiment wisdom language, does not have the world name and the benefit. Learn water under the hundred rivers, give up arrogant slow meaning.Learn to have a small return to feed root, willing to cast a conscience blog.
Decimal (numeric) synonymous with the exact storage of numeric values.
The decimal data type can store up to 38 digits, and all numbers can be placed to the right of the decimal point. The decimal data type stores an accurate (accurate) numeric
When you need to get text input in MFC, you often use CEdit or its subclasses. You can control some of the behavior of the edit control by setting its edit controls styles, for example, by setting the Es_number identity to allow the control to
Character and string processing functions: Character and string processing functions are all character data, but their return value types are different.1. Take the SUBSTRING function:Format: substr (C,N1,N2)Function: Take the string C N1 character
Decimal (numeric) synonymous for precise storage of numeric valuesfloat and real cannot store values accuratelyThe decimal data type can store up to 38 digits, and all numbers can be placed to the right of the decimal point. The decimal data type
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.