Hi, everyone
I want to introduce ODBC Unicode support patch.
Sorry for sending files instead of patch, but I cannot create it in my
environment.
I'm sending only modified files, so it is easy to create patch on server
end.
What I've done:
* all std::strings coming to and received from database now should be
UTF8,
this means that old good ANSI strings will work as before.
* all single characters now considered as Latin1-encoded 0..255 and
stored as unicode in DB
* by default library user can execute only query provided as ANSI
string,
but if it's not enough - define UNICODE macro or simply set "Use Unicode
Character Set"
If you working under VisualStudio. That will enable conversion and all
requests, table names
and constants will be considered as UTF8 strings.
* Above options are fully independent! You can leave project without
UNICODE definition
and still you will receive UTF8 strings in your requests
Remarks
* Yes, ve lost some performance, but tell me how to avoid that if you
want to use UTF8?
* There are some inefficiency in code but later we can optimize it.
Testing
* Tested under Win32/x64 environments with Access, MSQL7, MSQL8 and
MSQL9 - all passed
Questions
* Can someone test this patch under LINUX? with iODBC and UnixODBC (you
can submit results to me)
* Can we update documentation regarding unicode support for all Backends
somehow?
* Can we extend unittests for unicode checks?
--
Regards,
Stepanov Sergey
XMPP: [email protected]
ICQ: 200564264
SKYPE: sergey.y.stepanov
mobile: +7(921)345-78-22
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
