On 3/19/07, Juha Metsäkallas <[EMAIL PROTECTED]> wrote:
> Hello
>
> Note, that UPPER works only for 7-bit Latin characters. I'm also afraid
> that SQLite's collation NOCASE is only for 7-bit Latin characters. I.e.
> defining a collation or using UPPER doesn't work with e.g. Latin-1 or
> UTF-8. (htt
Hello
Note, that UPPER works only for 7-bit Latin characters. I'm also afraid
that SQLite's collation NOCASE is only for 7-bit Latin characters. I.e.
defining a collation or using UPPER doesn't work with e.g. Latin-1 or
UTF-8. (http://www.sqlite.org/lang_expr.html)
IIUC, SQLite lacks language
On 3/16/07, gary hayenga <[EMAIL PROTECTED]> wrote:
>
> On Mar 15, 2007, at 8:42 PM, realbasic-nug-
> [EMAIL PROTECTED] wrote:
>
> > On 3/15/07, Giulio <[EMAIL PROTECTED]> wrote:
> >> I would be interested too...
> >>
> >> anyway, I'm using as a workaround an upper() statement
> >>
> >> ORDER BY up
On Mar 15, 2007, at 8:42 PM, realbasic-nug-
[EMAIL PROTECTED] wrote:
>
> Date: Thu, 15 Mar 2007 12:24:41 -0700
> From: "Dennis Birch" <[EMAIL PROTECTED]>
> Subject: Re: Setting REALSQLDatabase sorting style (Dennis Birch)
> To: "REALbasic NUG"
>
> Message: 12
> Date: Thu, 15 Mar 2007 12:24:41 -0700
> From: "Dennis Birch" <[EMAIL PROTECTED]>
> Subject: Re: Setting REALSQLDatabase sorting style (Dennis Birch)
> To: "REALbasic NUG"
> Message-ID:
> <[EMAIL PROTECTED]>
>
At 8:19 AM -0700 15/3/07, Dennis Birch wrote:
>The REALSQLDatabase appears to use case-sensitive sorting when
>applying its ORDER BY clause to a SELECT statement. I'd like to be
>able to change it to non-case-sensitive.
>
>The documentation on SQLite.org refers to a COLLATION setting which
>can be
On 3/15/07, Giulio <[EMAIL PROTECTED]> wrote:
> I would be interested too...
>
> anyway, I'm using as a workaround an upper() statement
>
> ORDER BY upper(fieldname)
I haven't tried that, but wouldn't it convert the field text to all
uppercase? That wouldn't work for me.
__
On 3/15/07, Norman Palardy <[EMAIL PROTECTED]> wrote:
>
> On Mar 15, 2007, at 9:19 AM, Dennis Birch wrote:
>
> > The REALSQLDatabase appears to use case-sensitive sorting when
> > applying its ORDER BY clause to a SELECT statement. I'd like to be
> > able to change it to non-case-sensitive.
> >
> >
On Mar 15, 2007, at 1:37 PM, realbasic-nug-
[EMAIL PROTECTED] wrote:
>
> Date: Thu, 15 Mar 2007 08:19:13 -0700
> From: "Dennis Birch" <[EMAIL PROTECTED]>
> Subject: Setting REALSQLDatabase sorting style
> To: RBNUG
> Message-ID:
> <[EMAIL PROTECT
On Mar 15, 2007, at 9:19 AM, Dennis Birch wrote:
> The REALSQLDatabase appears to use case-sensitive sorting when
> applying its ORDER BY clause to a SELECT statement. I'd like to be
> able to change it to non-case-sensitive.
>
> The documentation on SQLite.org refers to a COLLATION setting which
0
> From: "Dennis Birch" <[EMAIL PROTECTED]>
> Subject: Setting REALSQLDatabase sorting style
> To: RBNUG
> Message-ID:
> <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> The REALSQLDatabase appears to use
The REALSQLDatabase appears to use case-sensitive sorting when
applying its ORDER BY clause to a SELECT statement. I'd like to be
able to change it to non-case-sensitive.
The documentation on SQLite.org refers to a COLLATION setting which
can be applied to a database or to separate tables for use
12 matches
Mail list logo
