Dear all, I'm working on ADO database driver for Glorp by using Pablo's PharoCOM. The structure of the driver is similar to Sven's P3DatabaseDriver and P3Client (thanks, Sven for very clear architecture :-) ) and the work is progressing quite nicely. I can connect to SQL Server, PostgreSQL and create tables, insert and read data directly with ADO Connection and Recordset objects, and with Glorp, too. In next days I'll do some more testing, including Oracle, and publish the prototype on GitHub. The goal is not PostgreSQL, of course, but to finally reach SQL Server, Oracle and possibly MS Access, at least from Windows systems.
One thing is bothering me though - SQL Server supports Unicode with NCHAR and NVARCHAR types, and when using INSERT INTO with literal strings these should be prefixed with N, like in N'This is a Unicode string' Does somebody remember whether Glorp can prefix the strings in that way when constructing SQL statements? I checked all the constants and string conversions under DatabasePlatform but haven't found anything related to this kind of prefixing. Thanks and best wishes, Tomaz -- Sent from: http://forum.world.st/Pharo-Smalltalk-Users-f1310670.html
