Archive: MSSQL_OLEDB can't pass Chinese word


MSSQL_OLEDB can't pass Chinese word
The problem should be in file MSSQL_OLEDB.cpp, line 338, function sprintf_s, this function should be changed to sprintf_w, in order to process Chinses word.


I will try to convert that function to support widechar, or I will create a new function (Executew or similar)
stay tuned


It would probably be wise to have Execute being wide as you cannot always know whether your query string will contain wide characters or not.

Stu


I'm trying to compile the source code, but VC6 + XP SP2 SDK with C2065 error
There is no fprintf_s definition. Can you please tell me what environment you used for compile the dll? Thank you.


Visual Studio 2005 SP1. I'm working on wide version. I'll post during the week end.


I'm very glade to heard that
:)


I managed to make MSSQL_OLEDB::SQL_ExecuteScript be aware of Unicode sql scripts.
I attach the plugin dll. try it. I will produce a new version of plugin and documentation in the next few days.
Keep in mind that NSIS is full ANSI, so you cannot use Unicode strings in any NSIS script.
In other words you cannot call MSSQL_OLEDB::SQL_Execute passing Unicode strings
regards
stefano


It's worked, thank you very much!


Glad to know that,
I'll soon release a new official version of the plugin supporting unicode scripts


Any way this (very nice) plugin will work with the unicode version of NSIS?

I already tried and when trying to logon i get some strange text back and login fails. (Logon works fine with the "normal" NSIS)


off for summer holidays.
will take a look at NSIS unicode when back in early september
stay tuned
Stefano


off for summer holidays.
enjoy!

:) did you have time to look at the NSIS Unicode yet?

Will MSSQL_OLEDB be able to handle scripts larger than the reported 60000 bytes anytime in the future?


*bump*

Any news on this?