Visualisation problem in DB2 for i

[pabloto]

Hi,

is this a visualisation problem?
Is there a configuration to omit this incorrect trim?

try this:

values (('    1')), (('12345'))

as you can see the number 1 of the first row is trim, but really it has to be below number 5 of the second row:

thank you.

---

⚠️ REMOVE THIS LINE AND ANY SENSITIVE INFORMATION BELOW! ⚠️

Context	Version
Code for IBM i version	2.14.5
Visual Studio Code version	1.97.2
Operating System	darwin_x64

Active extensions

COBOL (cobol): 25.2.25
Code Spell Checker (code-spell-checker): 4.0.39
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.5.0
Configuration Editing (configuration-editing): 1.0.0
Db2 for IBM i (vscode-db2i): 1.9.2
Dev Containers (remote-containers): 0.397.0
ESLint (vscode-eslint): 3.0.10
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.23.0
Git (git): 1.0.0
Git Base (git-base): 1.0.0
Git Graph (git-graph): 1.30.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
GitHub Copilot (copilot): 1.275.0
GitHub Copilot Chat (copilot-chat): 0.24.1
GitHub Pull Requests (vscode-pull-request-github): 0.104.1
GitLab Workflow (gitlab-workflow): 6.2.0
GitLens — Git supercharged (gitlens): 16.3.2
IBM i Debug (ibmidebug): 2.0.2
IBM i Project Explorer (vscode-ibmi-projectexplorer): 2.12.2
JSON Language Features (json-language-features): 1.0.0
Live Share (vsliveshare): 1.0.5948
Merge Conflict (merge-conflict): 1.0.0
Microsoft Account (microsoft-authentication): 0.0.1
Node Debug Auto-attach (debug-auto-launch): 1.0.0
Rainbow CSV (rainbow-csv): 3.17.0
Source Orbit (vscode-sourceorbit): 1.0.2
TODO Highlight (vscode-todo-highlight): 1.0.5
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0
Vue - Official (volar): 2.2.4
WSL (remote-wsl): 0.88.5

---

Remote system

Setting	Value
IBM i OS	V7R4M0
Tech Refresh	11
CCSID Origin	280
Runtime CCSID	280
Default CCSID	280
SSHD CCSID	?
cqsh	true
SQL	Enabled
Source dates	Disabled

Enabled features

/QOpenSys/pkgs/bin	/usr/bin	/QSYS.LIB	/QIBM/ProdData/IBMiDebugService/bin	/QOpenSys/QIBM/ProdData/JavaVM/jdk80
bash	attr	QZDFMDB2.PGM	startDebugService.sh	64bit
chsh	iconv
find	setccsid
grep	uname
ls
md5sum
sort
stat
tar
tn5250

Shell env

BUILDLIB=user
CURLIB=user
HOME=/home/user
HOST=IASP.directa.lan
LANG=IT_IT.UTF-8
LIBLS=QTEMP QGPL
LOGIN=user
LOGNAME=user
LS_COLORS=
MAIL=/var/spool/mail/user
OLDPWD=/IASP/home/user
PASE_USRGRP_LIMITED=N
PATH=/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PS1=\u@\h@\W$
PWD=/home/user
QIBM_PASE_CCSID=1208
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSH_CLIENT=192.168.0.23 29674 22
SSH_CONNECTION=192.168.0.23 29674 172.18.17.4 22
SSL_CERT_FILE=/home/cacert.pem
TZ=<CET>-1<CEST>,M3.5.0,M10.5.0
USER=user
USERNAME=user
WORKDIR=/home/user
_=/QOpenSys/pkgs/bin/env

Variants

{
  "american": "#@$",
  "local": "£§$"
}

[worksofliam]

Mapepire trimming spaces. Fixed in an upcoming release.