Welcome to the nuBuilder Forums!

Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.

Data base character encoding

Questions related to using nuBuilder Forte.
Post Reply
gniko
Posts: 8
Joined: Mon Mar 12, 2018 7:42 am

Data base character encoding

Unread post by gniko »

Hi,

I am trying to select a tool to create an online DB for my school. I like features of nuBuilder and it seems to be suitable for my needs.
However I face a problem with character encoding. Whenever I store anything using greek characters it is stored in the database as questionmarks ??

Using phpMyAdmin I saw that tables created using FastForms are InnoDB and encoding is latin1_sweedish
I altered the table encoding and columns encoding but I still face the same problem (tried both greek_ci and utf_8_general_ci)

If i change a record manually (using phpMyAdmin), nuBuilder reads the data correctly. So I sppose the problem is when writing to the db.

Anyone has an idea how to fix this problem, or which files should I look into to solve it?

I am trying nuBuilder Forte on my PC (using XAMPP).
PHP Version 5.6.33 and MariaDB
toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: Data base character encoding

Unread post by toms »

gniko,

I can't reproduce this. My DB collation is utf8_general_ci and when creating a new form/table using FastForms, are field have the encoding utf8_general_ci.
BTW, my setup is the same as yours.

Here is a dump of my test db:

http://s000.tinyupload.com/index.php?fi ... 7924189594
admin
Site Admin
Posts: 2829
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 times

Re: Data base character encoding

Unread post by admin »

gniko,

Fast Forms should now create MyISAM tables with utf8_general_ci fields.

You'll need the latest from Github.

Let me know if it now works for you.

Steven
gniko
Posts: 8
Joined: Mon Mar 12, 2018 7:42 am

Re: Data base character encoding

Unread post by gniko »

Thank you both!

Yes, my problem is solved everything looks ok now.
admin
Site Admin
Posts: 2829
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 times

Re: Data base character encoding

Unread post by admin »

.
Post Reply