Pavel Ivanov-2 wrote:
>
> On Wed, Nov 9, 2011 at 10:31 AM, hmas <i...@iode-informatique.fr> wrote:
>>>> Thanks for your answer.
>>>> foocol contains a string of numbers.
>>>> The result of typeof(foocol) is text.
>>>
>>> And what's the result of hex(foocol) ? My guess is you have some extra
>>> non-printable characters in there.
>>>
>> Hi,
>> Here are the results:
>> sqlite> select hex(foocol) from footable where foocol like
>> '999998012470700566';
>> 39393939393830313234373037303035363600
>
> Just as I said - extra '\0' character at the end which is not visible
> when you try to see the contents of the field, but is crucial for
> equality to fail.
>
>
> Pavel
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
Thanks a lot, that's exactly it.
I was binding the text with the null character terminating the string
I took it off and it works now
Herve
--
View this message in context:
http://old.nabble.com/select-...-where--%3D--or--like--tp32802547p32812483.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
