tags:

views:

20

answers:

0
Q: 

String equality and SQLite3

I'm experiencing a very strange issue with string equality in SQLite3. I have a table with a text column named type.

If I run select distinct type, 2 from mytable order by type (the 2 is there to get the pipe separator), I get:

...
Tops|2
...
Tops|2

i.e., the same column appears twice. This is causing me problems because queries with the where clause WHERE type ='Tops' only return rows that match the first 'instance' of tops.

Anyone know what's going on here? Is it a string encoding issue?

Curiously, running select distinct lower(type) from clothing_category where type ='tops' returns only one result. Somehow, the lower function resolves the issue.

related questions

Does anyone have a good Proper Case algorithm
Converting bool to text in C++
Does PHP have an equivalent to this type of Python string substitution?
PHP ToString() equivalent
What's the difference between a string constant and a string literal?
What would be the fastest way to remove Newlines from a String in C#?
Why is String.Format static?
PowerShell - How do I pass string parameters correctly?
What's the best string concatenation method using C#?
Java: Best way of converting List<Integer> to List<String>
C# String output: format or concat?
Parse usable Street Address, City, State, Zip from a string
C# Save Dialogs
How do I Convert a string to an enum in C#?
PowerShell - how do I do a string replacement in a function?
Case insensitive string comparison in C++
Why doesn't Ruby have a real StringBuffer or StringIO?
Checking for string contents? string Length Vs Empty String
Remove Quotes and Commas from a String in MySQL
Test serialization encoding
In C# what is the difference between String and string
String.indexOf function in C
What is the best way to parse strings in Java
Format string to title case
Generate list of all possible permutations of a string