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!
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.
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
-
- 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