Spaces in SQL and Conc

Former Member — Fri, 13 May 2011 07:58:04 GMT

Hello Everybody,

I'm writing a program that needs to take information, encrypt it, and then download it somewhere.

The problem I'm running into is using spaces in comparision and also concat.

I have a table with a range of ascii values ( 32 to 95 or so ), so everything some a space to a z in put inside it.

The problem works fine for characters and such, however if there is a space involved a complication starts.

a space has an ascii value of 32, So I've stored it in the database as ' ', and later I tried using SPACE.

[http://imgur.com/sCyoZ|http://imgur.com/sCyoZ]

So later in my code to get the value, I do a search of the table with if ascii_table->ascii_char = SPACE or ' ' then get the value there. The problem is that none of these tests return true. I've tried also with '' and it's also the same.

So my question being is it possible to put a single space in a sql line? Does anybody know how whitespace is actually managed and treated inside ABAP? Thank you very much!

- Bryan

Re: Spaces in SQL and Conc

Former Member — Fri, 13 May 2011 14:06:18 GMT

Hi Brian,

In db table fields with only whitespaces are considered empty.

For an explanation of how spaces are handled, please consult following [page|http://help.sap.com/abapdocu_702/en/abenliteral.htm] (especially the difference between ' and ` ).

For conversion from Unicode value to char and from char to unicode, please consider to use the methods UCCP and UCCI from both classes CL_ABAP_CONV_OUT_CE and CL_ABAP_CONV_IN_CE

Regards

topic Re: Spaces in SQL and Conc in Application Development and Automation Discussions

Spaces in SQL and Conc

Re: Spaces in SQL and Conc