PureBasic Forums - English

got it.
The first column (default) was empty.

Thanks mk-soft

Greetings,
Rudi

Hi,

I have a ListIcon gadget with data from a database.
I want to read the selected item, if possible a specific column.

I got the index, but the text gives me an empty result.

frmklanten_lstKlanten_index.i = GetGadgetState(#frmKlanten_lstKlanten)
frmklanten_lstKlanten_select.s ...

Hi,
Thanks for all these helpfull replys.
I should have given more explanaition.
Joplin is a notetaking application, offline first.
But you can synchronize over, amongst others Dropbox, Nextcloud,..
It also has an extension for the browser "Joplin web clipper" wich is a way to get information from ...

My json does not have back slashes. It doesn't work with the original download. The structure is not the same.

would be useful to have a JSON to PB structure converter to ease this

In the proces what I was missing is a clear way to get the structure. In the suggested solutions the structure is already known.
It was a pain to get that. I needed to debug to see the content. The JSON code comes through an ...

I tend to recreate the JSON structure, this makes evaluation much easier instead of using those weird JSON commands


How did you recreate the JSON structure? By hand?
If CreateJSON(#json)
jsonRoot = SetJSONArray(JSONValue(0))
SetJSONString(AddJSONElement(jsonRoot), jsonResult);"with escaped ...

Hi

I have this as a result from a download on Joplin. (jsonResult)

{"items":[{"id":"f4bfd5334d074a8ab5e414213561e1ea","parent_id":"1462c63203244ab88f5e729673ae87d1","title":"Core Zettel idee","deleted_time":0},{"id":"30e176160896445eacfdd0305e4d2f0a","parent_id":"1462c63203244ab88f5e729673ae87d1 ...

Hi Charvista

Great!

First I got Belgié but that was probabaly because I changed the charset a few times.
After changing the value in phpMyAdmin to België it fell into place.

I use:
DatabaseQuery(#Database, "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_520_ci ;")
this would give the most acurate ...

My fault, I have not read the documentation thoroughly.
There's a lot to read and learn. Step by step.
It changed to UsePNGImageDecoder() automaticly.
This is working fine now.

Thanks again mk-soft.
Greetings
Rudi

Temporaly solved it with:
EscapedValue$ = ReplaceString(RawValue$, "?", "ë")
But this will also change any other character that is not supported. So I could make it more specific like
EscapedValue$ = ReplaceString(RawValue$, "Belgi?", "België")
So this not a real solution yet.

mk-soft wrote: Sun Jan 11, 2026 4:22 pm I think (as I have read) umlauts are not allowed in the columns.

Which columns do you mean? MariaDB or PureBasic. Where did you read it? In phpMyAdmin the columns show the correct value.

Hi
I am on Ubuntu 22.04 and Purebasic 6.20
When I run a form designed with the form designer. And it has a image or a button image. The program stops unexpected. I can't add it afterwards or even in a manually designed window. So it's probably me doing it the wrong way.

the code of de form ...

It's via XAMPP 8.2.4-0
Config:
socket =/opt/lampp/var/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
default-character-set=utf8mb4
[mysqld]
user=mysql
port=3306
socket =/opt/lampp/var/mysql/mysql.sock
key_buffer=16M
max_allowed_packet=1M
table_open_cache=64 ...

It was utf8_general_c and it gave Belgi?.
PureBasic requires utf8
Couldn't select utf8 choise for utf8_bin instead. No solution.

Hi

I have a connection with my local MariaDB database. One of the columns returns "Belg?" instead of "België" in PureBasic.
The collation is "utf8_bin" already changed from "utf_general_ci".
I'm on Linux Ubuntu 22.04
In phpMyAdmin the value is "België".

result of the debugging, the value is ...