On 10/24/2013 9:46 AM, dd wrote:
Sorry Igor.
For ex, Employee has below columns:
column details:
1. seq_id as integer prmary key,
2. emp_id as STRING
3. emp_mngr_id as STRING
4. emp_id is UNIQUE
Programmatically, application converts integer to string for emp_id
and emp_mngr_id columns to insert into Employee table.
I would like to know about how sqlite maintains emp_id column. It
always contains integers in string format.
The type "STRING" has no special meaning to SQLite, therefore, the
columns have NUMERIC affinity, which is the default. This means that,
upon insertion, the value is converted to a number if it looks like one.
Thus, I predict that the values are actually stored as integers. For
details, see http://sqlite.org/datatype3.html
But again, you don't need to guess. Run the query I suggested earlier,
and you'll know for sure.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
