Re: [Artanis] database with Japanese text not displaying properly

[Nala Ginrut]

Hi Julio!

Julio Claudio Matus Ramirez writes:

> Hello Nala Ginrut,
> <% (DB-query conn "set names utf8") %>
>
> (adding this before calling the database query in the viewer)

This should be configurable in Artanis, I will consider how to do it
properly. The idea is that users shouldn't consider these stuff by themselves.
Thanks for point it out!

> It's the only way I could find to change the encoding for the client
> output. If you have any other solution/suggestion I'm very interested.
>
> It would be great if we could add random connection initilization raw
> strings/options as with other frameworks. Being able to call random sql
> code would be nice too (I'm guessing you didn't intend DB-query to be
> used in this way).

I've added a hook which should be triggered each time when DB is
initializing, it's named run-when-DB-init in (artanis utils). And you
should add your hook in ENTRY file:

--------------------ENTRY--------------------
(use-modules (artanis utils) (artanis artanis))
(run-when-DB-init
(lambda (conn)
(DB-query conn "set names utf8")))

(init-server) ; make sure the hook is registered before (init-server)
...
--------------------end---------------------

This will effect all pre-connected connections in conn-pool
automatically.

The commit is here:
https://gitlab.com/NalaGinrut/artanis/commit/1ae23e773f48d112c3a006ad214eec8a92686074

Could you try and feedback?
Thanks!

--
GNU Powered it
GPL Protected it
GOD Blessed it
HFG - NalaGinrut
Fingerprint F53B 4C56 95B5 E4D5 6093 4324 8469 6772 846A 0058

signature.asc
Description: PGP signature