SQL QUERIES

[Tomster]

Hey,

i'm trying different sql queries, but it seems that most of them are not working. I can select for instance all from Artists

SELECT * FROM ARTISTS

and it works well.

What does not work is the following:

SELECT * FROM ARTISTS WHERE Artist = 'a-ha'

I do need to use LIKE instead?

SELECT * FROM ARTISTS WHERE Artist LIKE 'a-ha'

It does work with the ID in both ways.

SELECT * FROM ARTISTS WHERE ID = 0
SELECT * FROM ARTISTS WHERE ID LIKE 0

The same thing happens to ORDER BY and all stuff regarding not table column 0.

So

SELECT * FROM ARTISTS ORDER BY ID

works,

SELECT * FROM ARTISTS ORDER BY Artist

does not.

So i have no idea why it's all working with column 0 of every table, but not with any other?

I'm using sqlite directly within a general plugin( sllite3.c )

[Guest]

Use this extension:
viewtopic.php?f=2&t=24841

[Guest]

How can is use a script extension within a plugin?

Still i need to know why it's not working.

[MMuser2011]

Maybe it is a collation and UNICODE Issue?
Do you get NOTHING as result or wrong entries?

[Guest]

Yes that's the case.

I need to use COLLATE NOCASE all over.

How does SQLite3_CreateCollation16() work, that i don't need to send it within my sql queries?

[MMuser2011]

Please login to the forum, otherwise all your posts are labeled with "Guest"

Unfortunately, I have no idea how to use SQLite3_CreateCollation16(). Everything I know, you already found in this thread viewtopic.php?f=2&t=25637&p=144852