ODBC Unicode support

Hi all,
I'm implementing application which uses international strings and needs
to store them in relational database (MS SQL server to be concrete). (As
Alan points out I use 'nvarchar' data types to store unicode strings.)
The SQL database is accessed through ODBCInterface. And here comes the
problem.
As I found out ODBC has two interfaces. One that can handle 8-bit
strings in any encoding and one that can handle UCS-2 strings.
Unfortunately VisualWorks ODBCInterface uses 8-bit interface (and
encodes all SQL statements acording actual locale). This implies to ODBC
that client application cannot handle unicode.
I can modify the ODBCInterface myself but I'd like to do it right and
not break any crucial component (like Store). So I'd like to discuss
some design issues with someone responsible for this part of VW.

Regards,
--
Ing. Milan Čermák
programátor, analytik

[hidden email]

................................................................
e-FRACTAL, s.r.o. => e-business driven company
nám. Míru 15, Praha 2, http://www.e-fractal.cz
tel: 222 512 000, fax: 222 515 000
................................................................