Page 1 of 1

Data base character encoding

Posted: Mon Mar 12, 2018 8:30 am
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

Re: Data base character encoding

Posted: Tue Mar 13, 2018 1:54 pm
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

Re: Data base character encoding

Posted: Wed Mar 14, 2018 3:42 am
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

Re: Data base character encoding

Posted: Thu Mar 15, 2018 12:42 pm
by gniko
Thank you both!

Yes, my problem is solved everything looks ok now.

Re: Data base character encoding

Posted: Thu Mar 15, 2018 6:02 pm
by admin
.