Guys.

I am using korma in my project.

I have to go trough utf8mb4.

But how can I implement this ?

What problem are you running into?

@scknkkrer are you getting error messages? Or mucking up strings? Or...what's going on that is making it just "not work"

nope, I almost write any character in my language, except 3 of them.

writing ? instead of these characters.

:db “olexi?characterSetResult=utf8mb4&characterSet=utf8mb4&collation=utf8mb4_unicode_ci” :useUnicode true :characterEncoding “UTF-8"

I try with this.

http://info.michael-simons.eu/2013/01/21/java-mysql-and-multi-byte-utf-8-support/ seems helpful

Also, what DB are you using and what version of that DB? (e.g., MySQL 5.5 doesn’t support full Unicode, even if you provide all the correct connection parameters)

Really ?

Wow.

Wait, connector or Database Server version ?

Server version.

But folks have asked for more details about your environment — which is good, basic debugging practice — what DB, what server version, what JDBC driver version, what does your db-spec look like, etc?

I would also recommend creating a small self-contained correct example — per http://www.sscce.org — and put it on GitHub (or in a Gist) so folks can take a look at the whole (small!) code to help you debug things.

it’s 5.7.16

thanks, I will read after fix this.

[mysql/mysql-connector-java “5.1.26”]

[korma “0.4.0”] [org.clojure/java.jdbc “0.3.7"]

all I have.

When I put this characters to my db direct, there is no problem.

only when I put it with clojure.

I’ll repeat my — still unanswered — question: what does your db-spec look like?

And, again, suggest you write a SSCCE without Korma, just with java.jdbc.

That will be the easiest way for you to debug this.

:db “dbname?characterSetResult=utf8mb4&characterSet=utf8mb4&collation=utf8mb4_unicode_ci?characterEncoding=UTF-8” :useUnicode true :characterEncoding “UTF-8" :characterSet “utf8mb4” :collation “utf8mb4_unicode_ci”

That’s not a valid db-spec for java.jdbc so I assume that’s what Korma expects and it’s doing something under the hood to create a db-spec for java.jdbc.

Like I say, create a SSCCE without Korma, so you can verify what parameters you need in your db-spec with java.jdbc, to make this work.

You may also want to check the docs for the mysql-connector-java library to see if there are fixes in more recent versions that will work with MySQL Server 5.7.16. We’re using 5.1.39 at work I think. We can’t use the 6.0.x driver since it doesn’t seem to work with MySQL 5.5 / 5.6 which we’re still on.

Thanks for your help.

one last question; isn’t there any problem while I read the data. It’s when I write.

Is that a question? I’m not sure what you’re asking.