Inserting Arabic into Database is not Working? about loopback-connector-mssql HOT 11 CLOSED

What database/conector are you using? Is your database set up to recognize UTF-8?

from loopback-connector-mssql.

My database is SQL Server 2012 using this connector "loopback-connector-mssql": "^2.2.0".

How to setup the database to recognize UTF-8?

from loopback-connector-mssql.

How to setup the database to recognize UTF-8?

This is not LoopBack specific, you will need to Google how to do it for your specific database. If you need direct support, we offer subscription plans. See https://strongloop.com/node-js/subscription-plans/. Closing for now, feel free to reopen once you confirm it's an actual LoopBack issue.

from loopback-connector-mssql.

So you think it is not loopback issue? I wasted 3 hours until now on how to configure the SQL Server to support UTF8 but it doesn't support that. I think the connector should convert data to something appropriate to be saved correctly in Arabic in database.

from loopback-connector-mssql.

@superkhau @raymondfeng
I have changed this line

https://github.com/strongloop/loopback-connector-mssql/blob/master/lib/mssql.js#L266

to:

return "N'" + val + "'";

This adds support to unicode and Arabic now is inserted and working well.

from loopback-connector-mssql.

Based on https://support.microsoft.com/en-us/kb/239530, your proposed change looks good to me. Do you want to submit a patch?

from loopback-connector-mssql.

Yeah sure

from loopback-connector-mssql.

@raymondfeng Here it is #52

from loopback-connector-mssql.

So you think it is not loopback issue?

I wasn't sure if it was yet, but I wanted you to confirm the database side before reopening the issue, which @raymondfeng has already done.

I wasted 3 hours until now on how to configure the SQL Server to support UTF8 but it doesn't support that. I think the connector should convert data to something appropriate to be saved correctly in Arabic in database.

Thanks for researching it and coming to the conclusion that it was Loopback related. As we look at a lot of issues, we appreciate that issues are confirmed before reporting. I will take a look at the patch and get it merged ASAP.

from loopback-connector-mssql.

@superkhau Thank you :)

from loopback-connector-mssql.

Resolved via #52.

from loopback-connector-mssql.