Re: [Firebird-net-provider] Special symbols getting converted to something else
Ok, I was able to dump it into a file. From the auto-detection that I ran
it through, it looks like it's either ISO-8859-1 or Windows-1252.
What exact strings would I put in my connection string to use one of those?
Here's my original line of code:
entityBuilder.ProviderConnectionString =
string.Format(character set=NONE;data source={0};initial catalog={1};;user
id={2};password={3};isolationlevel=ReadCommitted, connparams.server,
connparams.path, connparams.userid, connparams.password);
If I replace NONE with ISO-8859-1 or Windows-1252, I get an exception
saying:
The underlying provider failed on Open.
Invalid character set specified
Is there a list of valid character set constants that it will accept?
-Joe
On Tue, Nov 25, 2014 at 11:26 PM, Jiří Činčura j...@cincura.net wrote:
Study http://www.firebirdsql.org/refdocs/langrefupd25.html .
--
Mgr. Jiří Činčura
Independent IT Specialist
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Special symbols getting converted to something else
I'm having a strange problem. When special symbols are stored in my database, if the record is edited, it gets written back to the database as a different symbol or several symbols. Here's an example: I have a Firebird application that uses C++ and IBObjects. If I enter or paste into a database field some text containing the Trademark symbol ™ (typed alt-0153. Bytes are e2 84 a2), it shows correctly in the database, on the screen, etc. Now, if I access the same database record using .NET, the Firebird .NET provider, and Entity Framework, and edit that record, even if I don't modify the field containing the trademark symbol, when I save the record, it writes the trademark symbol back as: â„¢ (bytes are c3 a2 e2 80 9e c2 a2). Here is the code that I'm using: PRODUCT p = db.PRODUCTS.FirstOrDefaultPRODUCT(pp = pp.PRODBARCODE == ecp.PRODBARCODE pp.STOREID == _storeid); p.PRODWEBDIRTY = F; db.Entry(p).State = EntityState.Modified; db.SaveChanges(); Note that PRODWEBDIRTY is not the field containing the trademark symbol. I guess it's just writing back the entire record to the database, but with the special characters converted. Why does it do this? How can I prevent it? -Joe -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
The database was created with character set of NONE. In my C++/IBObjects project, the CharSet is Null. In my .NET project, the connection string has the character set as NONE. So what wouldn't be matching? I can't really change the database or the C++ project at this point. Too many users with many years of data stored the way it is now. What can I change in my .NET project to fix the issue that I'm having? -Joe On Tue, Nov 25, 2014 at 9:17 PM, Jiří Činčura j...@cincura.net wrote: You have very likely mismatch in charsets. To prevent it, basically, just use UTF8, everywhere. -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
Would there be a way to deduce the character that is being used by the C++ application by putting certain characters in, and then somehow examining what is actually stored in the database? -Joe On Tue, Nov 25, 2014 at 10:25 PM, Jiří Činčura j...@cincura.net wrote: Hard to say what charset the C++ is actually using. But using NONE on database was *very* bad choice. The encoding might be pretty screwed in. Use UTF8 in .NET, but I expect you’re going to do manual transliteration because of NONE charset used. -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
What tool could I use to dump it from the database in hex to a file? -Joe On Tue, Nov 25, 2014 at 10:44 PM, Jiří Činčura j...@cincura.net wrote: Absolutely. Put there some text. Dump it in hex to file. Open it in some “smart” editor – a lot of editors have a feature to guess encoding. You can also do it to with encoding tables. But that’s manual and slow. :) -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Special symbols getting converted to something else
I am not experienced with ISQL. Do you have an example of a command that would output the value of a VARCHAR field as hex? -Joe On Tue, Nov 25, 2014 at 11:06 PM, Jiří Činčura j...@cincura.net wrote: isql -- Mgr. Jiří Činčura Independent IT Specialist -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751iu=/4140/ostg.clktrk___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Entity Framework woes (cannot update model from database)
When I try to do Update model from database, I get the following error: An exception of type 'Microsoft.VSDesigner.Data.Local.ConnectionStringConverterServiceException' occurred while attempting to update from the database. The exception message is: ''. I searched this error, and I find a reply from Jiri from about a year ago that says, DDEX not installed correctly. I then performed the following steps: 1) Uninstalled the Firebird DDEX provider and the Firebird ADO.Net provider 2) Replaced machine.config in the following folders with the machine.config.default file: C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config 3) Reinstalled ADO.NET provider from NETProvider-4.1.0.0.msi 4) Reinstalled DDEX provider from DDEXProvider-3.0.1.0.msi However, I still get the same error. I can open the .EDMX file and view the entities, but I cannot update the model from the database. Here is my connection string: metadata=res://*/TRS11Model.csdl|res://*/TRS11Model.ssdl|res://*/TRS11Model.msl;provider=FirebirdSql.Data.FirebirdClient;provider connection string='initial catalog=C:\Program Files (x86)\TRS11\Data\DATA1100.FDB;user id=sysdba;password=masterkey;data source=localhost' The database path, userid, and password are all correct. Does this still sound like an issue with DDEX not being installed correctly? If so, what else should I do to install it correctly, if my above steps are not sufficient. -Joe -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird ADO.NET Data Provider 3.0.2 - installation ossue over VS 2010
When I've had trouble getting it installed correctly on a non-virgin machine, the following steps usually work for me: 1) Uninstall DDEX Provider 2) Uninstall Firebird ADO.Net Provider 3) Uninstall Visual Studio Professional 4) Reboot 5) Search the computer for all copies of machine.config in any .net framework folder. For each copy I find, I rename it to machine.config.BeforeDefaulting. Then, copy machine.config.default to machine.config (be sure to use the one in the same folder). Repeat for each copy of machine.config that was found. 6) Reboot again 7) Reinstall Visual Studio Professional 8) Reboot again 9) Reinstall Firebird ADO.Net Provider from the MSI 10) Reinstall DDEX Provider from the MSI 11) Reboot again Some of those reboots may not be necessary, but I do them all just to be sure. -Joe On Thu, Dec 27, 2012 at 6:48 AM, karasi v...@bk.ru wrote: Thank your for answering. Really, i tryed installing Driver with that sequesnce i've given above... First, MSI, then manually edited machine.cfg and importing REGs. But without manually installing after running MSIs actually there was no Firebird Data Source in New data source dialog in VS. And only manual i found was readme.txt in DDEX. -- View this message in context: http://firebird.1100200.n4.nabble.com/Firebird-ADO-NET-Data-Provider-3-0-2-installation-issue-over-VS-2010-tp4632552p4632572.html Sent from the firebird-net-provider mailing list archive at Nabble.com. -- Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnmore_122712 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
