Subject Re: How to truncate text to fit in a db field the easiest way in Firebird?
I just tested out different things, after i have been thinking of this issue. 
I really didn't want to have to escape the text. It should be exact as it shows.

Escaping text shows it will be more coding on different modules, and the text is never the exact size.
I tried with Parameterized queries instead.
Now i don't have to escape the text.

Parameterized queries was the solution to keep it exact as it shows on screen.
Now i don't need to check for the input size either. It would have been a lot of extra work on that.

This was a relief.

Parameterized queries is the best solution for saving text i found out. You don't have to worry about any special characters.

Best Regards
Viggo Jamne