[es] - Kako iskljuciti/ukljuciti case sensitive na access bazi

Deep|Blue
Srce Srbije

Član broj: 631
Poruke: 1431
*.yu1.net.

ICQ: 101830817

+314 Profil

Kako iskljuciti/ukljuciti case sensitive na access bazi

^{29.11.2005. u 09:46 - pre 223 meseci}

Problemcic, vb.net aplikacija koristi access bazu, koja je izgleda kreirana sa ukljucenim case sensitive.
Tako da se maltretiramo sa upitima. Posto ne mogu nigde da nadjem kako se ovo podesava, ima li neko ideju kako to ide?

"Hmmm", rekao je, "...suprostavlja se nadrealizmu prikrivene metafore..." Razmišljao je tome na trenutak, a onda je zatvorio beležnicu s mrkim osmehom.
"I smrt je za njih suviše dobra"

Odgovor na temu

Zidar
Canada

Moderator
Član broj: 15387
Poruke: 3085
*.eqao.com.

+79 Profil

Re: Kako iskljuciti/ukljuciti case sensitive na access bazi

^{29.11.2005. u 14:43 - pre 223 meseci}

Sto se tice baze (same tabele) nisam siguran da se tu moze definisati case sensitivity. U VB kodu medjutim moze. Na pocetku svakog modula obicno pise Option Compare Database => not case sensitive
Ako je Option Compare Binary =. case sensitive
Mozda je nesto od toga u pitanju?

evo iz Access VBA help:

Citat:

Option Compare Statement

Used at module level to declare the default comparison method to use when string data is compared.

Syntax

Option Compare {Binary | Text | Database}

Remarks

If used, the Option Compare statement must appear in a module before any procedures.

The Option Compare statement specifies the string comparison method (Binary, Text, or Database) for a module. If a module doesn't include an Option Compare statement, the default text comparison method is Binary.

Option Compare Binary results in string comparisons based on a sort order derived from the internal binary representations of the characters. In Microsoft Windows, sort order is determined by the code page. A typical binary sort order is shown in the following example:

A < B < E < Z < a < b < e < z < À < Ê < Ø < à < ê < ø

Option Compare Text results in string comparisons based on a case-insensitive text sort order determined by your system's locale. When the same characters are sorted using Option Compare Text, the following text sort order is produced:

(A=a) < ( À=à) < (B=b) < (E=e) < (Ê=ê) < (Z=z) < (Ø=ø)

Option Compare Database can only be used within Microsoft Access. This results in string comparisons based on the sort order determined by the locale ID of the database where the string comparisons occur.

Odgovor na temu