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
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Data base character encoding
-
- Posts: 785
- Joined: Sun Oct 14, 2018 11:25 am
Re: Data base character encoding
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
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
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
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
-
- Posts: 8
- Joined: Mon Mar 12, 2018 7:42 am