|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
June 16th, 2007, 01:22 PM
|
|||
|
|||
|
Firebird Syntax Case Sensitive
i have this syntax :
"select count(data) from table where data='Test'" and execute on scalar it will return 0 but i have data='test' is there any setting about this case sensitive? on sql i don't have this problem thx
|
|
#2
June 16th, 2007, 01:54 PM
|
||||
|
||||
|
It depends on the collation used (this means that you can have case sensitive search on SQLServer too, just the default collation is ..._ci case insensitive), not on the database server.
If you want case insensitive search in Firebird you can turn everything to upper/lower case, do a search on this forum, subject has been discussed many times.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Firebird Syntax Case Sensitive |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
