# Problem it ö, ä, ü on MySQL **URL:** \ **Category:** Schema & Data\ **Created:** [November 9, 2015, 10:35am UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744 "2015-11-09T10:35:47Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![pitw](https://avatars.discourse-cdn.com/v4/letter/p/b5e925/32.png) [@pitw](https://community.dreamfactory.com/u/pitw)\ **Post date:** [November 9, 2015, 10:35am UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/1 "2015-11-09T10:35:47Z")
Hi Probably found a bug: If using a MySQL - DB with german ö, ä, ü API Docs gave this error: “The Response content must be a string or object implementing \_\_toString(), “boolean” given.” Example: Zürich \>\>\> Error Zuerich \>\>\> OK MySQL - DB is set to UTF-8. ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [November 9, 2015, 1:24pm UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/2 "2015-11-09T13:24:07Z")
Thanks. I will test this and file a bug report. What version of DreamFactory are you running, and what operating system? ---
**Author:** ![pitw](https://avatars.discourse-cdn.com/v4/letter/p/b5e925/32.png) [@pitw](https://community.dreamfactory.com/u/pitw)\ **Post date:** [November 9, 2015, 4:03pm UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/3 "2015-11-09T16:03:07Z")
Bug appears on V. 2.0.1. I tested on Bitnami VMWare - Version and on Dreamfactory Enterprise Instance. Probably caused by Laravel… ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [November 9, 2015, 4:42pm UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/4 "2015-11-09T16:42:37Z")
Thank you. I’ll take a look and update you. ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [November 9, 2015, 7:55pm UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/5 "2015-11-09T19:55:21Z")
Can you provide the following. What is the collation for your database? Provide the table and field collations as well if they are different. Provide the schema dump from dreamfactory for this table GET /{service\_name}/\_schema/{table\_name} How (through what tool/interface) was the data originally entered into the table? ---
**Author:** ![pitw](https://avatars.discourse-cdn.com/v4/letter/p/b5e925/32.png) [@pitw](https://community.dreamfactory.com/u/pitw)\ **Post date:** [November 9, 2015, 9:52pm UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/6 "2015-11-09T21:52:23Z")
I just created a fresh DB / Table with some demo data. Column with ID 1 works, Column with ID 2 causes problems… SQL - File for import (MySQL): CREATE TABLE IF NOT EXISTS `test` ( `ID` int(11) NOT NULL, `Test1` varchar(200) NOT NULL, `Test2` longtext NOT NULL, `Test3` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `test` (`ID`, `Test1`, `Test2`, `Test3`) VALUES (1, ‘demotest’, ‘Some really long text for testing…’, ‘Other text’), (2, ‘Zürich’, ‘Zürich in Switzerland’, ‘Zürich also in CH’); This is schema dump: { “name”: “test”, “is\_view”: false, “label”: “Test”, “plural”: “Tests”, “description”: null, “alias”: null, “field”: [ { “name”: “ID”, “label”: “ID”, “description”: null, “type”: “integer”, “db\_type”: “int(11)”, “length”: 11, “precision”: null, “scale”: null, “default”: null, “required”: true, “allow\_null”: false, “fixed\_length”: false, “supports\_multibyte”: false, “auto\_increment”: false, “is\_primary\_key”: false, “is\_foreign\_key”: false, “is\_unique”: false, “is\_index”: false, “ref\_table”: null, “ref\_fields”: null, “picklist”: null, “validation”: null, “alias”: null }, { “name”: “Test1”, “label”: “Test1”, “description”: null, “type”: “string”, “db\_type”: “varchar(200)”, “length”: 200, “precision”: null, “scale”: null, “default”: null, “required”: true, “allow\_null”: false, “fixed\_length”: false, “supports\_multibyte”: true, “auto\_increment”: false, “is\_primary\_key”: false, “is\_foreign\_key”: false, “is\_unique”: false, “is\_index”: false, “ref\_table”: null, “ref\_fields”: null, “picklist”: null, “validation”: null, “alias”: null }, { “name”: “Test2”, “label”: “Test2”, “description”: null, “type”: “text”, “db\_type”: “longtext”, “length”: null, “precision”: null, “scale”: null, “default”: null, “required”: true, “allow\_null”: false, “fixed\_length”: false, “supports\_multibyte”: true, “auto\_increment”: false, “is\_primary\_key”: false, “is\_foreign\_key”: false, “is\_unique”: false, “is\_index”: false, “ref\_table”: null, “ref\_fields”: null, “picklist”: null, “validation”: null, “alias”: null }, { “name”: “Test3”, “label”: “Test3”, “description”: null, “type”: “text”, “db\_type”: “text”, “length”: null, “precision”: null, “scale”: null, “default”: null, “required”: true, “allow\_null”: false, “fixed\_length”: false, “supports\_multibyte”: true, “auto\_increment”: false, “is\_primary\_key”: false, “is\_foreign\_key”: false, “is\_unique”: false, “is\_index”: false, “ref\_table”: null, “ref\_fields”: null, “picklist”: null, “validation”: null, “alias”: null } ], “related”: [], “primary\_key”: null, “name\_field”: null, “access”: 31 } ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [November 10, 2015, 2:41pm UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/7 "2015-11-10T14:41:27Z")
Thank you @pitw. I confirmed the behavior and filed this as a bug yesterday. ---
**Author:** ![DecaFL](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@DecaFL](https://community.dreamfactory.com/u/DecaFL)\ **Post date:** [November 12, 2015, 2:15am UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/8 "2015-11-12T02:15:45Z")
Hello @formerstaff! , I am also facing the same issue…if it helps, I also noticed that if you try to set a service (admin/data/Select DB Service) on a table that contains extended characters it will show a popup giving the same error: “DreamFactory Table Module The Response content must be a string or object implementing \_\_toString(), “boolean” given.” And on Swagger if you get the records using application/xml instead of application/json, it will retreive all records that does NOT contain extended characters…the ones that contains , it will return just the tags with an empty field. example below ( “\<” replaced by “[” so it shows here ) [?xml version=“1.0” ?\> [dfapi\> [resource\> **[razao\_social\_cliente\>[/razao\_social\_cliente\>** [cidade\_cliente\>[/cidade\_cliente\> [nome\_fantasia\_cliente\>EVENTOS CANTALOUP [/nome\_fantasia\_cliente\> [/resource\> [/dfapi\>"" Looking forward to a fix 😄 thank you ! ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [November 17, 2015, 2:35pm UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/9 "2015-11-17T14:35:54Z")
Still working on this but wanted to let you know if you create the records using the API they are stored and retrieved with no problem. It’s only existing data. ---
**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\ **Post date:** [November 19, 2015, 7:57pm UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/10 "2015-11-19T19:57:00Z")
I have been able to resolve this by adding a charset parameter to the connection string. for mysql this means `mysql:host=localhost;port=3306;dbname=mydb;charset=utf8` ---
**Author:** ![dracon](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/dracon/32/554_2.png) [@dracon](https://community.dreamfactory.com/u/dracon)\ **Post date:** [January 5, 2016, 11:44pm UTC](https://community.dreamfactory.com/t/problem-it-o-a-u-on-mysql/1744/11 "2016-01-05T23:44:55Z")
Thank you! This saved it for me 🙂