Board index » delphi » Case insensitive collation

Kelvin Chua

Delphi Developer
Wed, 12 May 2004 10:58:22 GMT

Case insensitive collation

Hi there,

How should I set the case insensitive collation?  I would like to have the
data sorted in case insensitive manner.  Currently, the UPPERCASE is sorted
first and LOWERCASE later, and that had consituted some major problems when
I try to locate the record with "%".

Thanks.

Kelvin Chua
SINGAPORE

 
Kelvin Chu

Delphi Developer
Wed, 12 May 2004 10:56:30 GMT

Re:Case insensitive collation


Hi there,

How should I set the case insensitive collation?  I would like to have the
data sorted in case insensitive manner.  Currently, the UPPERCASE is sorted
first and LOWERCASE later, and that had consituted some major problems when
I try to locate the record with "%".

Thanks.

Kelvin Chua
SINGAPORE

Claudio Valderrama C

Delphi Developer
Wed, 12 May 2004 13:07:40 GMT

Re:Case insensitive collation


http://www.brookstonesystems.com
Then you need to declare charset and collation for fields. You can declare
charset globally, but collation is a per-field setting.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase? WebRing

Quote
"Kelvin Chua" <NOkelvinS...@accpro.com.sg> wrote in message

news:3bff0c33$1_1@dnews...
Quote
> Hi there,

> How should I set the case insensitive collation?  I would like to have the
> data sorted in case insensitive manner.  Currently, the UPPERCASE is
sorted
> first and LOWERCASE later, and that had consituted some major problems
when
> I try to locate the record with "%".

> Thanks.

> Kelvin Chua
> SINGAPORE

Kelvin Chu

Delphi Developer
Wed, 12 May 2004 12:21:09 GMT

Re:Case insensitive collation


Hi Claudio,

Thank you very much.

Kelvin Chua
SINGAPORE

"Claudio Valderrama C." <cva...@willbounce.org> wrote in message
news:3bff1c88_1@dnews...

Quote
> http://www.brookstonesystems.com
> Then you need to declare charset and collation for fields. You can declare
> charset globally, but collation is a per-field setting.

> C.
> --
> Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
> Independent developer
> Owner of the Interbase? WebRing

> "Kelvin Chua" <NOkelvinS...@accpro.com.sg> wrote in message
> news:3bff0c33$1_1@dnews...
> > Hi there,

> > How should I set the case insensitive collation?  I would like to have
the
> > data sorted in case insensitive manner.  Currently, the UPPERCASE is
> sorted
> > first and LOWERCASE later, and that had consituted some major problems
> when
> > I try to locate the record with "%".

> > Thanks.

> > Kelvin Chua
> > SINGAPORE

Martijn Tonie

Delphi Developer
Sun, 16 May 2004 06:06:53 GMT

Re:Case insensitive collation


You can change the characterset that you're using to use the collation you
want as the default - that at least takes some work away from you :)

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

"Claudio Valderrama C." <cva...@willbounce.org> wrote in message
news:3bff1c88_1@dnews...

Quote
> http://www.brookstonesystems.com
> Then you need to declare charset and collation for fields. You can declare
> charset globally, but collation is a per-field setting.

> C.
> --
> Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
> Independent developer
> Owner of the Interbase? WebRing

> "Kelvin Chua" <NOkelvinS...@accpro.com.sg> wrote in message
> news:3bff0c33$1_1@dnews...
> > Hi there,

> > How should I set the case insensitive collation?  I would like to have
the
> > data sorted in case insensitive manner.  Currently, the UPPERCASE is
> sorted
> > first and LOWERCASE later, and that had consituted some major problems
> when
> > I try to locate the record with "%".

> > Thanks.

> > Kelvin Chua
> > SINGAPORE

Other Threads

1. Case Sensitive vs Case-InSensitive

2. case sensitive search, collation drivers problem

3. CASE INSENSITIVE Boyer Moore

4. How to make InterBAse query case insensitive?

5. Using case insensitive SQL strings in delphi 2.0 C/S

6. Case Insensitive Match using SQL- How to?

7. How to perform a case-insensitive query?

8. How to make SQL query case insensitive?

9. Sort Stringfields case insensitive - how?

10. Case insensitive queries in D3