Pavel Ivanov-2 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.
>
>
> Pavel
>
>
> On Tue, Nov 8, 2011 at 12:11 PM, hmas <[email protected]> wrote:
>>
>>
>> Simon Slavin-3 wrote:
>>>
>>>
>>> On 8 Nov 2011, at 10:58am, hmas wrote:
>>>
>>>> My application insert into a table a string of numbers (for exemple
>>>> '999998011295918220'.
>>>> if I do (either from command line or from my c++ program)
>>>> select foocol from footable where foocol = '999998011295918220'
>>>> the result set is empty
>>>
>>> I'm trying to figure out whether that string of digits was stored as a
>>> string or a number. Please do
>>>
>>> SELECT foocol,typeof(foocol) FROM footable WHERE foocol LIKE
>>> '999998011295918220'
>>>
>>> and tell us what the results are.
>>>
>>> Simon.
>>>
>>> Thanks for your answer.
>>> foocol contains a string of numbers.
>>> The result of typeof(foocol) is text.
>>> Herve.
>>>
>>> _______________________________________________
>>> sqlite-users mailing list
>>> [email protected]
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>>
>>
>> --
>> View this message in context:
>> http://old.nabble.com/select-...-where--%3D--or--like--tp32802547p32803113.html
>> Sent from the SQLite mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> sqlite-users mailing list
>> [email protected]
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
Hi,
Here are the results:
sqlite> select hex(foocol) from footable where foocol like
'999998012470700566';
39393939393830313234373037303035363600
sqlite> select hex(foocol) from footable where foocol =
'999998012470700566';
sqlite>
select .... where ... =
returns void
The characters seem well coded
herve
--
View this message in context:
http://old.nabble.com/select-...-where--%3D--or--like--tp32802547p32811722.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
