CODEWITHSUNDEEP
javasqlhibernateunicode
Will Warren
Will Warren

Reputation: 1294

Hibernate + JPA + jTDS + SQL Server = Unicode Problems

I maintain a piece of software that runs as a Servlet and can make use of MySQL, Oracle or SQL Server as the DB backend - depending on what the Customer wants to use.

Everything works perfectly with MySQL and Oracle, and SQL Server works great too, except I cannot insert/update Unicode sequences into the database.

I can do a manual insert in SQL Server Management Studio of a unicode sequence like this

INSERT INTO mytable (msg) VALUES (N'Modern Standard Hindi (मानक हिन्दी), is a standardised and Sanskritised register of the Hindustani language.')

This data is output in my software correctly, so this verifies that the database and the web front end can both handle unicode no problem.

And here's my connection string

jdbc:jtds:sqlserver://<server ip>:1433/MyDb

As I said, Oracle and MySQL work perfectly using this setup. What's different about SQL Server?

Note: I also tried the official Microsoft-provided JDBC driver with exactly the same results.

If it makes a difference, I'm using JPA Repositories to do my DB interactions. The whole webapp is also set up as a SpringMVC application.

Edit: I also tried adding useUnicode=true;characterEncoding=UTF-8 to the end of my connection string with the same results

Upvotes: 0

Views: 3411

Answers (2)

Will Warren
Will Warren

Reputation: 1294

So there was one thing I left off my original question.

I had the system set up with Spring Security and a CharacterEncodingFilter in the filter chain to force UTF-8 in all requests and responses, but I had it set up in the afterSpringSecurityChain section of my web security initializer.

I moved the filter into the beforeSpringSecurityChain method and boom - everything UTF-8 works perfectly with all DB vendors.

I ended up not adding any params to my connection string or anything either. It was literally just the filter that I changed.

Upvotes: 2

Breand&#225;n Dalton
Breand&#225;n Dalton

Reputation: 1639

You may need to specify in your connection string that you're using Unicode, and also what encoding you're using. Maybe something like this?

jdbc:jtds:sqlserver://<server_ip>:1433;databaseName=MyDb;useUnicode=true;characterEncoding=UTF-8

Upvotes: 2

Related Questions