[SR-Users] SQLite datatypes

[Timo Teras]

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