Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums 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: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 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: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Data base character encoding

Unread post by admin »

.
Post Reply