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