On 24 Oct 2013, at 3:12pm, dd wrote:
> SELECT typeof(emp_id), typeof(emp_mngr_id) FROM employee;
>
> typeof(emp_id) | typeof(emp_mngr_id)
>
> text text
> text text
> ...
> text text
Then they're stored as text. An
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 T
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 ins
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 l
On 10/24/2013 8:39 AM, dd wrote:
One of the column stores 'long long int' as string in database in
production. Internally, sqlite maintains it as a integer or text?
I'm not sure I understand the question. Didn't you just say "stored as
string"? What do you mean by that, if not "maintained a
Hi,
One of the column stores 'long long int' as string in database in
production. Internally, sqlite maintains it as a integer or text?
If Text, is there any performance overhead if I write a query based
on this column?
Can I get better performance If I write a query based on integer
c
6 matches
Mail list logo
