CODEWITHSUNDEEP
charfirebirdvarchar
Dan
Dan

Reputation: 77

Firebird queries using chars/varchar

I am using SQLManager Lite for firebird and it was impossible so far to write a query which would do an operation on char/varchar columns. Character set is win1252.

A query like 

select * from Person where name = 'John'

won't return any results despite the fact that the record exists in the database. A similar query on a numerical column works just fine. AM I am missing anything here?

Also, this query runs fine from my application. The only issue is that I would like to be able to run it within SQLManager Lite too. As a side note, values for char and varchar columns are not displayed properly within the same SQLManager Lite.

Upvotes: 0

Views: 743

Answers (1)

dataol
dataol

Reputation: 1009

change to like

select * from Person where name like 'John'

Upvotes: 2

Related Questions