SQL insert/update removes spaces

Question

Question

Michael Lundberg · Aug 15, 2022

Hi!

I have a question regarding SQL insert/update from the mananger portal's SQL window.

I am trying to do an insert with a value that contains multiple spaces ($32) between two words. This is needed for a comparative reason. But the spaces are automatically trimmed away all the time. How should I write to keep these?

Example:

Insert into TableA
(MyColumn) Values('xxxx yyyy')

then the spaces are trimmed away and it becomes: 'xxxx yyyy'

But I want to keep the spaces. How do I get around the problem?

Regards,
Michael

Product version: IRIS 2022.1

Discussion (4)1

Log in or sign up to continue

Julius Kavay Aug 15, 2022 to Michael Lundberg

The only tricky thing is the (web)management portal. Put the following few lines into a "test.html" file and the open it with your favorite browser.

<html>
<head></head>
<body>
A   simple  text     with    some spaces<br>
<pre>A   simple  text     with    some spaces</pre>
</body>
</html>
ObjectScript
ObjectScript

You see the difference?

1 0

score 0 · Answer 1 · 2022-08-15T04:52:54-04:00

Did you check this or are you just saying that? What does this query show?

select MyColumn, length(MyColumn) from TableA
ObjectScript
ObjectScript

score 0 · Answer 2 · 2022-08-15T05:10:38-04:00

Thanks for reply.

This was tricky. Maybe I'm being visually deceived.

The text I am trying to enter is 24 characters long. If I take the selected value after and paste it into notepad, it shows the length 21.

But your suggestion to try SQL select length on that column/value shows the value 23

/Michael

score 0 · Answer 3 · 2022-08-15T07:26:59-04:00

Hey!

You are absolutely right! I was also starting to think it was the html presentation. But I initially thought it would be like wysiwyg in the SQL window of the portal.

Thank you so much and you explained the "conundrum" for me :O)

Regards, Michael