Possibly related : while exploring ⎕SQL, I noticed some misha dling of non-ASCC
nin-APL Unicode.
After running :
```
⍝ Exploration of a sqlite database throug APL
⍝ Nota Bene : The database name *MUST* be an UNENCAPSULATED vector :
MaDBName←'/home/charpent/Documents/Perso/SuiviMédical/Circulation.sqlite'
⍝ Connection
MaDB←'sqlite' ⎕SQL[1] MaDBName
⍝ Dictionary Tables
TableNames←⎕SQL[8] MaDB ⍝ Returns a *VECTOR* !
⍝ Dictionary : Views. This could be a new ⎕SQL function
⍝ Nota Bene : SQL queries ALSO must be UNENCAPSULATED...
ViewNames← ,'select name from sqlite_schema where type = ''view'';' ⎕SQL[3,
MaDB] '' ⍝ Returns a MATRIX* !
⍝ Dictionary Table/view columns (sqlite colum types are of questionable value)
ColumNames←(TableNames,ViewNames),[1.5]MaDB {⊃(⍺ ⎕SQL[9] ⊃⍵)[;1]}¨
TableNames,ViewNames
```
I noticed :
```
⍝ Compare
ColumNames
Circulation Date
Poids
TA Systolique
TA Diastolique
Pouls
CircData Date
nDate
Poids
TA Systolique
TA Diastolique
Pouls
CD2 Date
nDate
Poids
Pouls
TA Systolique
TA Diastolique
TA Moyenne
TA Différentielle
⍝ with
7 ⎕CR ColumNames
┌→──────────┐ ┌→─────────────┐
│Circulation│ ↓Date │
└───────────┘ │Poids │
│TA Systolique │
│TA Diastolique│
│Pouls │
└──────────────┘
┌→───────┐ ┌→─────────────┐
│CircData│ ↓Date │
└────────┘ │nDate │
│Poids │
│TA Systolique │
│TA Diastolique│
│Pouls │
└──────────────┘
┌→──┐ ┌→─────────────────┐
│CD2│ ↓Date │
└───┘ │nDate │
│Poids │
│Pouls │
│TA Systolique │
│TA Diastolique │
│TA Moyenne │
│TA Diff⏃⎩rentielle│
└──────────────────┘
```
`7 ⎕CR` mishandles the non-ASCII column names of `CD2`. Could this be related
to the mishandling of functuon definition that appeared *after* the releaase of
the current Debian package of Gnu APL ?
HTH,
--<br>
Emmanuel Charpentier
[ Snip... ]
