0
because if u do it as number then the 0 at the start would automatically be removed so u write in text otherwise the data would be wrong
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
Is blob a real number?
yes blob is a real numberBLOB. The value is a blob of data, stored exactly as it was input. So it could be text or numbers.
Are Data are always numerical measurements.?
No. Data can mean any information, text, graphics or numeric that has t be stored, used , reported on , investigated or used for reasearch
Which data type is better to use for storing phone number in the following format 977-1-1234567?
Phone numbers should always be stored in a text format and never as in a number field. There are several of reasons for this. You never do calculations with phone numbers; you may have a zero at the start of a phone number, which would disappear if left in a number format and you may, as in this case, have other characters in a phone number that are not digits, which would not be accepted in a number format.
What is the number of characters that can be stored and displayed in a cell formatted as Text?
160 characters it all depends on what phone
What type of data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255?
memo
What indicates the type of data that can be stored in a field?
The data type, like Number, Date, Time, Text etc.
What is a type check on a database?
Checking that data types are correct for what they are needed for. If data types don't match or are of the wrong type, it can cause problems. Dates should not be stored as text for example.
Is blob a real number?
yes blob is a real numberBLOB. The value is a blob of data, stored exactly as it was input. So it could be text or numbers.
What happens when text is entered into a number field?
A number field will not accept text. If it does accept text, then it cannot be a number field. Text fields can accept digits, but number fields cannot accept other text. They will only accept digits and other numeric components, like a decimal point for example. Sometimes you will define a field for numbers, such as phone number or code numbers to be text fields. In fact, that is what you should do for that type of data. You never do calculations with phone numbers, like adding them or getting averages, so they can be stored in text fields, as there is no need for them to be stored in number fields. Also, a zero at the start of a phone number, would disappear if entered into a number field, and it would also not allow things like spaces or brackets.
What types of data can be stored in a text data type field?
A text data type field can store alphanumeric characters, such as letters, numbers, and special symbols. It is suitable for storing large amounts of text data, such as descriptions, comments, or notes. Text data types can hold variable lengths of text, depending on the database system used.
Why is the telephone number stored as text on an access database?
Some telephone numbers starts with number 0 (zero) or the country code with + marks (If you type the full number properly). For instance a number like 0094111234567 or +94111234567. If this number is stored under the "Number" data type, two things can happen. 1. Default "Number" field does not support this size of data. You have to change the Filed Size to "Double" in order to accommodate this telephone number. 2. Zero (0) in the front will get removed automatically! So To prevent these issues you can use the data type as "Text" Hope this Helps!
What types of computerized information or records are stored in a database?
A database can store various types of computerized information or records such as customer data, employee information, sales transactions, inventory levels, website content, and financial records. The type of information stored in a database depends on the needs and requirements of the organization using it.
What device converts text or images on an original document into digital data that can be stored and processed by a computer?
bitmap
What happens if you convert memo data type to text?
When you convert a memo data type to text, any text stored in the memo field will be converted to plain text format. Any formatting, such as line breaks or special characters, may be lost during this conversion.
What are 5 types of data that can be stored in a cell in an excal spreadsheet?
Text, Date, Time, Logical and number. The numbers can be formatted lots of ways, like as currency or percentage. The number types are all number types, just formatted differently.
Is text an access data type?
No, "text" is not an access data type. In Microsoft Access, commonly used data types include Text, Number, Date/Time, Memo, and Yes/No among others. Text is used to store alphanumeric data such as names or descriptions.
What is text data in access?
The field can contain any characters. A maximum number of 255 characters is allowed in a field whose data type is Text.
