Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

(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 4 years ago
109 Answers

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 4 years ago

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

Internet Explorer: Mozilla Firefox: Google Chrome: