使用chars/varchar的Firebird查询 [英] Firebird queries using chars/varchar

问题描述

我正在将SQLManager Lite用于firebird，到目前为止，尚不可能编写对char/varchar列进行操作的查询.字符集是win1252.

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.

类似

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?

此外，该查询在我的应用程序中运行良好.唯一的问题是，我也希望能够在SQLManager Lite中运行它.附带说明，在同一SQLManager Lite中，char和varchar列的值未正确显示.

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.

推荐答案

更改为喜欢

select * from Person where name like 'John'

这篇关于使用chars/varchar的Firebird查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！