On Thu, 17 May 2012 15:02:30 -0300 Sebastian Ferguson
<sebastian.fergu...@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
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
