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
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
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
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
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
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
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
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,
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
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
10 matches
Mail list logo