Thanks Igor. It's text.
I ran below to query: SELECT typeof(emp_id), typeof(emp_mngr_id) FROM employee; typeof(emp_id) | typeof(emp_mngr_id) text text text text .... ... text text On Thu, Oct 24, 2013 at 5:55 PM, Igor Tandetnik <[email protected]> wrote: > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
