Is there a string notation like #32 in FirebirdSQL?

[hamacker]

Hi ALL,

Is there a string notation like #32 in FirebirdSQL?

To use in my sql function/procudures, it´s too bad code looking for space as ' '.

[Karol Bieniaszewski]

Hi

 

No, you can use built in function:

ASCII_CHAR(32)

 

But it is even more hard to read then ‘ ‘ 😉

 

Regards,

Karol Bieniaszewski

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/CAA09Jk_4HWQgmR9abTHKzBvcVS_Qtaye39P0V8%3DTGL1LM%2BYdVQ%40mail.gmail.com.

 

[hamacker]

Well,

I declare constant variables using this method for complex procedures, using emptyStr for empty string or q for quote.
Days before  I found notation for hex, then I thought that there existed one for string?

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/4MRq8S0kqtz1qdW%40smtp.poczta.onet.pl.

[Mark Rotteveel]

No, Firebird doesn't have escapes like this. In theory you could use a
binary string literal, but using concatenation like 'normal' || x'20' ||
'string' feels a bit odd to me.

If Firebird adds Unicode string literals, you could use
U&'unicode#0032string' UESCAPE '#', but as far as I'm aware this is not
yet planned.

Mark
--
Mark Rotteveel

[hamacker]

I will try to request it, maybe in the next release, it's not too difficult.

constant like emptystr, will be welcome too.