Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SqlServer uses setNString #32314

Open
yeapornope opened this issue Jul 29, 2024 · 4 comments
Open

SqlServer uses setNString #32314

yeapornope opened this issue Jul 29, 2024 · 4 comments

Comments

@yeapornope
Copy link

shardingsphere version : 5.3.2
SQL SERVER VERSION: 2017

Data of the NVARCHAR data type cannot be written properly when using shardingsphere

Through the code can be found in the AbstractUnsupportedOperationPreparedStatement setNString has been write die throw an exception

The question is:

  1. Is there an extended way to set setNString properly
    C99F5513-2D91-4537-B905-525FE13443C5
  2. Current I have through the TypeHandler setNString method will be replaced by setString method, can write, but for business reason sendStringParametersAsUnicode = false must adjust to false, Therefore, the correct information cannot be obtained when the sql query is used, and the Chinese data is written as???? Therefore, you want to change the way to implement NVARCHAR
    222

Want to ask whether there are other processing methods in the latest version, please prompt

@yeapornope
Copy link
Author

yeapornope commented Jul 29, 2024

The sharding mode used is shardingsphere-JDBC

@terrymanu
Copy link
Member

No plan to support for now, does any one want to do it?

@yeapornope
Copy link
Author

Since the database we use is SQLSERVER, we have encountered this problem in the process of integrating shardingsphere, and we want to solve this thing
Or if there is an interface that can be extended, we can extend the setNString method ourselves
Because we need it for our business, so far

@yeapornope
Copy link
Author

Looking forward to your reply, thank you

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants