I've read unicode strings from SQL server over ODBC, but connection needs to be switched to unicode mode. _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
session := (self connection getSession)
unicodeEncoding: #'UCS-2'; unicode: true; yourself. session etc etc -Boris -- +1.604.689.0322 DeepCove Labs Ltd. 4th floor 595 Howe Street Vancouver, Canada V6C 2T5 http://tinyurl.com/r7uw4 [hidden email] CONFIDENTIALITY NOTICE This email is intended only for the persons named in the message header. Unless otherwise indicated, it contains information that is private and confidential. If you have received it in error, please notify the sender and delete the entire message including any attachments. Thank you. > -----Original Message----- > From: Boris Popov > Sent: Tuesday, April 01, 2008 11:28 AM > To: '[hidden email]'; '[hidden email]' > Subject: Re: [vwnc] Reading Unicode excel files via ODBC > > I've read unicode strings from SQL server over ODBC, but connection needs > to be switched to unicode mode. > > Cheers! > > -Boris (via BlackBerry) > > ----- Original Message ----- > From: [hidden email] <[hidden email]> > To: VWNC <[hidden email]> > Sent: Tue Apr 01 11:23:00 2008 > Subject: [vwnc] Reading Unicode excel files via ODBC > > Hi > > Has anyone been successfulin reading unicode strings from > an Excel file using ODBC? > > Terry > > =========================================================== > Terry Raymond > Crafted Smalltalk > 80 Lazywood Ln. > Tiverton, RI 02878 > (401) 624-4517 [hidden email] > <http://www.craftedsmalltalk.com> > =========================================================== > > _______________________________________________ > vwnc mailing list > [hidden email] > http://lists.cs.uiuc.edu/mailman/listinfo/vwnc _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
Boris
The problem is that ODBC is telling me that the column is type 12 (SQL_VARCHAR) instead of SQL_WVARCHAR. Where I would expect an extended charcter I get a '?' character instead. I suspect it is an issue with the Excel ODBC driver. Terry =========================================================== Terry Raymond Crafted Smalltalk 80 Lazywood Ln. Tiverton, RI 02878 (401) 624-4517 [hidden email] <http://www.craftedsmalltalk.com> =========================================================== > -----Original Message----- > From: Boris Popov [mailto:[hidden email]] > Sent: Tuesday, April 01, 2008 2:31 PM > To: [hidden email]; [hidden email] > Subject: RE: [vwnc] Reading Unicode excel files via ODBC > > session := (self connection getSession) > unicodeEncoding: #'UCS-2'; > unicode: true; > yourself. > session etc etc > > -Boris > > -- > +1.604.689.0322 > DeepCove Labs Ltd. > 4th floor 595 Howe Street > Vancouver, Canada V6C 2T5 > http://tinyurl.com/r7uw4 > > [hidden email] > > CONFIDENTIALITY NOTICE > > This email is intended only for the persons named in the message > header. Unless otherwise indicated, it contains information that is > private and confidential. If you have received it in error, please > notify the sender and delete the entire message including any > attachments. > > Thank you. > > -----Original Message----- > > From: Boris Popov > > Sent: Tuesday, April 01, 2008 11:28 AM > > To: '[hidden email]'; '[hidden email]' > > Subject: Re: [vwnc] Reading Unicode excel files via ODBC > > > > I've read unicode strings from SQL server over ODBC, but connection > needs > > to be switched to unicode mode. > > > > Cheers! > > > > -Boris (via BlackBerry) > > > > ----- Original Message ----- > > From: [hidden email] <[hidden email]> > > To: VWNC <[hidden email]> > > Sent: Tue Apr 01 11:23:00 2008 > > Subject: [vwnc] Reading Unicode excel files via ODBC > > > > Hi > > > > Has anyone been successfulin reading unicode strings from > > an Excel file using ODBC? > > > > Terry > > > > =========================================================== > > Terry Raymond > > Crafted Smalltalk > > 80 Lazywood Ln. > > Tiverton, RI 02878 > > (401) 624-4517 [hidden email] > > <http://www.craftedsmalltalk.com> > > =========================================================== > > > > _______________________________________________ > > vwnc mailing list > > [hidden email] > > http://lists.cs.uiuc.edu/mailman/listinfo/vwnc _______________________________________________ vwnc mailing list [hidden email] http://lists.cs.uiuc.edu/mailman/listinfo/vwnc |
Free forum by Nabble | Edit this page |