Data base character encoding

Questions related to using nuBuilder Forte.

Data base character encoding

Postby gniko » Mon Mar 12, 2018 5:00 pm

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
gniko
 
Posts: 2
Joined: Mon Mar 12, 2018 4:12 pm

Re: Data base character encoding

Postby toms » Tue Mar 13, 2018 10:24 pm

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
toms
toms
 
Posts: 411
Joined: Wed Nov 08, 2017 8:57 pm

Re: Data base character encoding

Postby admin » Wed Mar 14, 2018 12:12 pm

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
admin
Site Admin
 
Posts: 2483
Joined: Mon Jun 15, 2009 9:53 am

Re: Data base character encoding

Postby gniko » Thu Mar 15, 2018 9:12 pm

Thank you both!

Yes, my problem is solved everything looks ok now.
gniko
 
Posts: 2
Joined: Mon Mar 12, 2018 4:12 pm

Re: Data base character encoding

Postby admin » Fri Mar 16, 2018 2:32 am

.
admin
Site Admin
 
Posts: 2483
Joined: Mon Jun 15, 2009 9:53 am


Return to General