Dear Richard,
Thanks a lot for the quick reply. Please find the reply for your queries
* Which models of Philips MP3 players are using SQLite?
All the Hard disc audio juke box (MP3-HDD player)models of
Philips for the year 2004 and 2005 are using the Sqlite database.
* What other OSS is used in Philips MP3 players?
I am a developer working in the design centre in Bangalore
and I do not have the list of OSS other than Sqlite that is used in the
creation of the Philips MP3 players.
* When is Philips going to begin supporting Ogg Vorbis?
I am not sure when Ogg Vorbis support shall be available
in the Philips MP3 players. Currently we have only MP3/WMA support.
* Where is your design team located?
The software design team is located in Bangalore and I am
a member of the software development group.
Regards,
Sankara Narayanan B
"D. Richard Hipp" <[EMAIL PROTECTED]>
2004-12-07 06:53 PM
Please respond to
[EMAIL PROTECTED]
To
[EMAIL PROTECTED]
cc
Subject
Re: [sqlite] URGENT - ORDER BY , COLLATE combination clarification
required
[EMAIL PROTECTED] wrote:
>
> CLARIFICATION REQUIRED:
> If I have a non-text column (say integer column like iDirId) at the end
in
> the order by clause I find that collate nocase is not performed. Is this
> the expected behaviour? If so how could I have the nocase collation for
> the cPlaylistName even though I want the ordering sequence as above in
> Query 2?
>
The COLLATE clause applies to the term of the ORDER BY to which it
is attached. If you put the COLLATE on the iDirId, it works on that
column. If you want it to nocase the cPlaylistName, attach it to the
cPlaylistName column.
Now I have questions for you:
* Which models of Philips MP3 players are using SQLite?
* What other OSS is used in Philips MP3 players?
* When is Philips going to begin supporting Ogg Vorbis?
* Where is your design team located?
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
