[Firebird-net-provider] Special symbols getting converted to something else

2014-11-25 Thread Joseph Martinez
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

Re: [Firebird-net-provider] Special symbols getting converted to something else

2014-11-25 Thread Jiří Činčura
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

Re: [Firebird-net-provider] Special symbols getting converted to something else

2014-11-25 Thread Joseph Martinez
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

Re: [Firebird-net-provider] Special symbols getting converted to something else

2014-11-25 Thread Jiří Činčura
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

Re: [Firebird-net-provider] Special symbols getting converted to something else

2014-11-25 Thread Joseph Martinez
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

Re: [Firebird-net-provider] Special symbols getting converted to something else

2014-11-25 Thread Jiří Činčura
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

Re: [Firebird-net-provider] Special symbols getting converted to something else

2014-11-25 Thread Joseph Martinez
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

Re: [Firebird-net-provider] Special symbols getting converted to something else

2014-11-25 Thread Jiří Činčura
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,

Re: [Firebird-net-provider] Special symbols getting converted to something else

2014-11-25 Thread Joseph Martinez
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

Re: [Firebird-net-provider] Special symbols getting converted to something else

2014-11-25 Thread Jiří Činčura
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