Subject Re: [firebird-support] Swedish characters in LIKE
Author Pavel Menshchikov
Hello Sven,

p> I use a select statement like:
p> My problem is that if the value is not spelled with a upper case this
p> statement does not work.
LIKE is case-sensitive. Use CONTAINING - that's case-insensitive.

p> I suppose I have to change the character set, but wich one should I
p> use and how do I do it?
Name you current character set and collation. But if your query above
works, then most probably you have right (or at least appropriate)
character set and collation, because otherwise UPPER(FIELD1) wouldn't
upper-case Swedish-specific characters and LIKE would return false for
such data.

Best regards,
Pavel Menshchikov