On Thu, 17 May 2012 15:02:30 -0300 Sebastian Ferguson
<sebastian.ferguson(a)gmail.com> wrote:
I've tryied with varchar(20) (lowercase) before I
sent the original
e-mail and it doesn't work. And I have tryied storing data as a
number and as a stirng (I know that sqlite has not stict type
definitios).
After your e-mail I've built the database again like this (all
uppercase as you recommend (and as it should be ;-)):
sqlite> CREATE TABLE traducciones('zona' VARCHAR(25), 'e100'
sqlite> VARCHAR(20),
'e101' VARCHAR(20), 'e102' VARCHAR(20));
sqlite> INSERT INTO traducciones
VALUES("caballito","1557311721","1557311721","08103330303");
sqlite> INSERT INTO traducciones
VALUES("flores","63793266","08103330303","1557311721");
sqlite> select * from traducciones;
caballito|1557311721|1557311721|08103330303
flores|63793266|08103330303|1557311721
AND NOW IT's WORKING!!!!!
Ok. Thanks for the confirmation. I'll fix this sometime this or next
week to work case-insensitively.
The production table will have all emergency numbers
in Argentina
(10x, 13x, 911).
Very nice :)
-Timo