Right, because those ANSI VB6 controls do W->A conversions using the systems current ANSI codepage. It would be possible to avoid this behaviour by using the replacement VB6 controls in fm20.dll which support Unicode and don't make such conversions. That way SQL Studio could handle Unicode data without depending on the systems locale settings. Those controls in fm20.dll are the same that MS Office uses for its VB macros (i.e. Textbox control in Office can handle Unicode data, Textbox Control in VB6 can not). It should be little work to make SQL Studio use the Unicode enabled controls as their interfaces are compatible.
Right now you can use Unicode in all queries (i.e. inserting data into a table) nicely while using a completely unrelated ANSI codepage in the system, but you cannot view any results. SQL Studio is still a very nice standalone tool, WebSQL might not be a good replacement in all cases. > -----Original Message----- > From: Auer, Wolfgang [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 13, 2003 10:28 AM > To: 'Watz'; [EMAIL PROTECTED] > Subject: RE: SQL Studio + UNICODE > > > Hi, > > to use SQL Studio with unicode data you have to change the > "Regional Options"->"Default Locale" to the language you > want to work with. If you don't want to change this I > recommend the WebSQL as unicode tool. > > > Regards > Wolfgang > > -----Original Message----- > From: Watz [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 12. August 2003 20:27 > To: [EMAIL PROTECTED] > Subject: SQL Studio + UNICODE > > > Hi, > > I just fiddled around with the latest SQL studio on a Unicode > installation and noticed that the non-Unicode enabled VB6 > standard controls are used (textbox, checkbox, label etc.). > The query edit control is Unicode enabled (nice!). > > There are Unicode-enabled replacements for these non-Unicode > VB6 controls in FM20.DLL ("Microsoft Forms 2.0"). It would be > nice to be able to handle Unicode Data in SQL Studio in all > its controls without depending on the Windows ANSI codepage. > FM20.DLL not redistributable but I do believe its part of > every Windows installation since Win95OSR2. > > Is there any chance that this will still be fixed in SQL Studio? > > Regards, > Watz > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
