Is string comparison in CUBRID case insensitive?

Question

1

(click on this box to dismiss)

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

91

Answer 1

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

284

Related Questions