Devart Forums

OK playing around with this I tried a very simple:

"Select {fn CHAR(id)}, id from Client"

this should return 1 and 11, but
the built in Data Editor shows EmptyStr and garbage.. so does a data grid.

ID is an Integer field in a Firebird 2.5 Db

As it is stated in the SQL function paragraph of the Unified SQL section in UniDAC help: http://www.devart.com/unidac/docs/unisql.htm the CHAR function returns a character corresponding to the digital value of the passed argument. The character matching the code 11 is unreadable, so you see the empty string.

Got it, the function to use is 'TOCHAR'..

thanks

Thank you for your interest to our product. Feel free to contact us if you have any further questions.