Notebook I :Data not showing

'Select * from mylib.mytable limit 10' is not showing any data.
'Select mycol1,mycol2,mycol3,mycol4... blah blah(all columns) from mylib.mytable limit 10' is not showing any data.
'Select 1 as Number from mylib.mytable limit 1' shows 10 rows.
'Select mycolumn from mylib.mytable limit 10' is randomly showing data.
I noticed that same table in different libraries , once created via CRTPF and CCSID 280 is not shown , while same table create via CREATE TABLE in a different Library and CCSID 1144 is properly shown.

|Context|Version|
|-|-|
|Code for IBM i version|2.17.2|
|Visual Studio Code version|1.105.1|
|Operating System|darwin_arm64|

Active extensions

```
Atlassian: Jira, Rovo Dev, Bitbucket (atlascode): 4.0.4
Code Coverage for IBM i (code-coverage-ibmi): 0.1.7
Code Runner (code-runner): 0.12.2
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.5.0
Configuration Editing (configuration-editing): 1.0.0
Continue - open-source AI code agent (continue): 1.2.9
Db2 for IBM i (vscode-db2i): 1.15.1
ESLint (vscode-eslint): 3.0.16
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.26.0
Extension Authoring (extension-editing): 1.0.0
GistPad (gistfs): 0.9.5
Git (git): 1.0.0
Git Base (git-base): 1.0.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
GitHub Copilot (copilot): 1.372.0
GitHub Copilot Chat (copilot-chat): 0.32.1
GitLens — Git supercharged (gitlens): 17.6.1
IBM i Debug (ibmidebug): 3.0.0
IBM i Notebooks (vscode-ibmi-notebooks): 0.0.6
IBM i Project Explorer (vscode-ibmi-projectexplorer): 2.12.3
IntelliCode (vscodeintellicode): 1.3.2
JSON Language Features (json-language-features): 1.0.0
JavaScript Debugger (js-debug): 1.105.0
Live Server (LiveServer): 5.7.9
Makefile Tools (makefile-tools): 0.12.17
Markdown All in One (markdown-all-in-one): 3.6.3
Markdown Language Features (markdown-language-features): 1.0.0
Markdown Math (markdown-math): 1.0.0
Merge Conflict (merge-conflict): 1.0.0
Microsoft Account (microsoft-authentication): 0.0.1
NPM support for VS Code (npm): 1.0.1
Node Debug Auto-attach (debug-auto-launch): 1.0.0
Prettier - Code formatter (prettier-vscode): 11.0.0
Pylance (vscode-pylance): 2025.8.3
Python (python): 2025.16.0
Python Environments (vscode-python-envs): 1.10.0
Quarto (quarto): 1.126.0
RPGLE (vscode-rpgle): 0.33.2
Render Line Endings (render-crlf): 1.9.2
Server Ready Action (debug-server-ready): 1.0.0
Source Orbit (vscode-sourceorbit): 1.4.1
Terminal Suggest for VS Code (terminal-suggest): 1.0.1
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0
YAML (vscode-yaml): 1.19.1
```

Remote system

|Setting|Value|
|-|-|
|IBM i OS|V7R4M0|
|Tech Refresh|9|
|CCSID Origin|1144|
|Runtime CCSID|1144|
|Default CCSID|1144|
|SSHD CCSID|?|
|cqsh|true|
|SQL|Enabled
|Source dates|Enabled

### Enabled features

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

Shell env

```bash
BUILDLIB=XX
CURLIB=XX
HOME=/home/hm
HOST=xxx.xxx.xxx.xxx
LIBLS=mYLIBLIST
LOGIN=xx
LOGNAME=xx
MAIL=/var/spool/mail/xx
OLDPWD=/home/xx
PATH=/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PWD=/home/xx
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
SSH_CLIENT=xxx.xxx.xxx.xxx 22
SSH_CONNECTION=xxx.xxx.xxx.xxxxxx.xxx.xxx.xxx 22
TZ=-1,M3.5.0,M10.5.0
USER=xx
USERNAME=xx
WORKDIR=/home/xx
_=/QOpenSys/pkgs/bin/env
```

Variants

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

No source file or test is named. Start by reproducing the notebook queries against the CRTPF and CREATE TABLE versions, comparing their CCSIDs and the displayed results. Done means rows and selected columns display consistently for the affected table and CCSID combinations.

Written by the indexing model from the issue text.