How to allow utf-8 unicode (utf8) storing on dreamfactory?

Schema & Data
1

Any idea how can utf-8 unicode (utf8) storing be allowed on dreamfactory?

1 Like
2

Hi,

in theory, you set the supports_multibyte option on fields that shall support UTF-8 content. But due to the following bug, those settings won’t be persisted when made inside the DSP.

(cannot post this link as it counts as more than two links) github.com/dreamfactorysoftware/dsp-core/issues/59

3

This bug will be resolved in the next release mid-January.

4

Thanks @spackmat @benbusse , will be waiting for the next update

5

Does support for UTF8 now exist in DreamFactory 2.0? As I’m still seeing ??? (question mark) characters where Unicode characters should be

6

Upon further investigation, the supports_multibyte: true option is showing in the table definition when I do a sample API request to see schema e.g. /api/v2/{resource}/_schema/{table_name}, but I’m still seeing questions marks (???) in the response to single or multiple records e.g. /api/v2/{resource}/_table/{table}/{id} where there should be UTF8 characters instead

7

I managed to solve my own problem in Dreamfactory 2.0 by editing the Connection String (DSN) field found in Services -> (your service) -> Config tab -> Connection String (DSN) field -> mysql:host=localhost;port=3306;dbname={dbname};charset=utf8;. Also, just to note that DreamFactory managed to correctly identify which fields needed to be supports_multibyte: true so it required no further configuration other than this to support UTF8 databases. Also, I am using MySQL and have not tried other databases.

1 Like
8

@jasdeepkhalsa, thanks for that tip. That resolved a general issue I’ve been investigating with accented characters.

9

A post was split to a new topic: Help with utf-8 in platform.api