Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


1
(click on this box to dismiss)

Is string comparison in CUBRID case insensitive?

When CUBRID performs a string search, does it use case-insensitive comparison or case-sensitive? Is there any parameter to control this behavior?

link comment (0) accepted answer
asked 3 years ago
eye
91
109 Answers
2

It depends on how you do the comparison. Assume you have a table users which has a record where name = 'eye'.

SELECT * FROM users WHERE name = 'Eye';

= operator will give no results, since it is case-sensitive.

SELECT * FROM users WHERE STRCMP(user_id, 'Eye') = 0;

STRCMP function will return that record regarless the case.

link comment (0)
answered 3 years ago
sqlcopter
284
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: