In this tutorial we';; check out the data type options we have available for use in SQL. We'll talk about Bigint, int, smallint, tinyint, decimal, number, float, char, varchar, blob, datetime, date, time and year.

hey ! I just stored an image in my database using the blob datatype.. now when i try to retrieve it in matlab i am not able to.. while i can retrieve all other information present in my table but not the image.. can u provide some guidance relating to this?

HI Madhur,
I am using SQL server.
Can you pls let me know how to add alphanumeric character into a column.
which datatype has to be used while creating the table?
I tried using VARCHAR datatype, but got an error while inserting DATA(O123) into the table.

If you were just storing known values, like for example, school grades (A, B, C, D, F), then I'm sure varchar would waste space... char data type would probably save space.
I'm not sure what the exact implementation details are... but if i were to implement char & varchar, char would have ONE length field... Versus varchar... which would have either a length field PER ENTRY... or a null terminator for each value.
Using the above specification & an example class size of 20 students, the amount of memory to store just their grades for the CHAR data type would be 20 bytes *plus* the size of the length field.
The amount of memory to store the same data set using VARCHAR would be 40 bytes (each entry has a null terminator according to our specification) *plus* the size of the max_length field.
You have a good question. Hopefully, my example specification & class room example didn't confuse you. I was just trying to show a situation in which CHAR is better than VARCHAR.

Would you like to comment?

Marin Community Foundation and Asian Americans/Pacific Islanders in Philanthropy.
Overall, US-born Muslims make up the largest percentage at 34% of all Muslims in the Bay Area, followed by 14% born in Pakistan, 11% in Afghanistan, 10% in India, 3% in Egypt and 2% each in Iran, Jordan, Palestine and Yemen.
Silicon Valley Pakistani-American by the Numbers:
There are 35,000 Pakistani-born Muslims in San Francisco Bay Area, or 14% of the 250,000 Muslims who call the Bay Area home, according to the study. Bay Area Muslim community constitutes 3.5 percent of the area’s total population and is one of the highest concentrations of Muslims in the country.
As of 2013, South Asian Muslims, including Pakistanis, have the highest income levels, with nearly half (49%) of them having a household income above $100,000. In comparison, those groups with the lowest proportion of household incomes above $100,000 were Hispanic Muslims (15%), Afghans (10%), and African American Muslims (10%).

The Bay Area Muslim community is very diverse in terms of race and ethnicity:
South Asians (30%)
African Americans (9%)
Asian/Pacific Islanders (7%)
Based on the survey findings, the majority of Muslims live in the following three counties:
and Contra Costa (12%)
Thousands of Pakistan-born techies are working at Apple, Cisco, Google, Intel, Oracle and hundreds of other high-tech companies from small start-ups to large Fortune 500 corporations. Pakistani-Americans are contributing to what Erik Brynjolfsson and Andrew McAfee describe as "The Second Machine Age" in a recent book with the same title.