On Thu, 17 May 2012 15:02:30 -0300 Sebastian Ferguson sebastian.ferguson@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