PureBasic Forums - English

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 ...

// DB
define('DB_DRIVER', 'mysqli');
define('DB_HOSTNAME', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'opencart_db');
define('DB_PORT', '3306');
define('DB_PREFIX', 'oc_');

According to the documentation of PureBasic this would work:

Hi
I have a ...

Thanks for clarifying TI-994A

I will dive deeper into modules.

Already in love with PureBasic.
But after a long marriage...

Greetings from Belgium
Rudi

So modules act as events. Module::event()?
I will look if this would make life simpler. In the meantime I have about 8 windows running.

Templates make a difference. So does issues.

I found how to copy the prefs. Would be nice to see a way to backup or transfer them in the IDE.

I think in VB and ...

It was taking it over. But the second time it is gone. Not workable. I 'solved' it by manualy coding the menu's in de procedures file. It's getting more clear bit by bit. I'm getting to a system that will be good to build larger applications that is manageable for maintaining. I'm using the template ...

Select added Menu Item and change at right side properties
- Constant
- Name

Not much use that you can change this. Every time you switch to code the change is gone. Can this be changed in the behaviour of the formdesigner?

If you work with multiple forms, you must assign unique names to all Window, Gadget, Menu constants (variables) in the FormDesigner.
Then there are no conflicts.

(Or you take my EventDesigner) :mrgreen:

I had the enummeration wrong too.
On the main windows were
Enummeration Windows
...
The ...

Hi,

Happy New year.

I got the application working with different forms. The forms created with the form designer have two files now (see code below).
I had to do some changes to get it all working. I have put some comments in the code.

The generated form:
;
; This code is automatically ...