Hello to everyone,
First off:
1. Used Firebird Version & Model:
Firebird-2.5.1 - Embedded (x86)
2. Operating System
Windows 7 Enterprise x64
Windows 7 Professional x64
Windows 7 Enterprise x86
Windows 7 Professional x86
3. Language
C# + .NET-Provider FirebirdSql.Data.FirebirdClient (Version 2.6.0, I couldn't
get 2.6.5 to work)
My Problem:
I am building a database which heavily relies on XML-Data. The problem is that
I cannot get any XML-Data into the database, the db refuses to accept the data
and always throws "Token Unknown in line 3 Column 122 s" - which is strange,
because even if I actually change the statement for insertion or do an update
on the xml-field, I always get "line 3 Column 122 s", it refuses to accept the
XML as a value. When I use any other string (for example
"TESTTESTTESTTESTTEST") it works however.
Here is my insert statement:
FbCommand DBCommand = new FbCommand("INSERT INTO games (name_of_game, info_xml)
VALUES ('" + GameToInsert.Name + "', '" + XMLString + "')", DBConnector,
DBTransaction);
DBCommand.ExecuteNonQuery();
DBTransaction.Commit();
Now - if I do an insert on the "name_of_product"-field, it works fine. The
info_xml however refuses everything. The field is a "BLOB SUB_TYPE TEXT"-type
field. I cannot seem to get a grasp why this happens - can someone help me out
here? How do I insert the XML into the db?
Thanks in advance for your replies,
Thomas Bueter
P.S.:
An example for the full insert statement (I also tried with removing the ", no
luck either):
INSERT INTO games (name_of_game, info_xml) VALUES ('Rage',
'<Game><gamesdbid>895</gamesdbid><GameTitle>Rage</GameTitle><Platform>PC</Platform><ReleaseDate>10/07/2011</ReleaseDate><Overview>Rage
is a groundbreaking first-person shooter set in the not-too-distant future
after an asterogamesdbid impacts Earth, leaving a ravaged world behind. You
emerge into this vast wasteland to discover humanity working to rebuild itself
against such forces as ragamesdbider gangs, mutants, and the Authority -- an
oppressive government regime that has a special interest in you in particular.
Featuring intense first-person action, vehicle combat, an expansive world and
jaw-dropping graphics powered by gamesdbid's revolutionary gamesdbidTech 5
technology, Rage continues the legacy of design studio Id Software in
delivering an experience like no other.</Overview><ESRB>M -
Mature</ESRB><Genres><genre>Shooter</genre></Genres><Players>1</Players><Co-op>No</Co-op><Youtube>http://www.youtube.com/watch?v=OVX9V_Uf30Q?hd=1</Youtube><Publisher>Bethesda
Softworks</Publisher><Developer>ID
Software</Developer><Rating>10</Rating><Images><fanart><original
wgamesdbidth="1920"
height="1080">http://thegamesdb.net/banners/fanart/original/895-1.jpg</original><vignette
wgamesdbidth="1920"
height="1080">fanart/vignette/895-1.jpg</vignette><thumb>http://thegamesdb.net/banners/fanart/thumb/895-1.jpg</thumb></fanart><fanart><original
wgamesdbidth="1920"
height="1080">http://thegamesdb.net/banners/fanart/original/895-2.jpg</original><vignette
wgamesdbidth="1920"
height="1080">fanart/vignette/895-2.jpg</vignette><thumb>http://thegamesdb.net/banners/fanart/thumb/895-2.jpg</thumb></fanart><fanart><original
wgamesdbidth="1920"
height="1080">http://thegamesdb.net/banners/fanart/original/895-3.jpg</original><vignette
wgamesdbidth="1920"
height="1080">fanart/vignette/895-3.jpg</vignette><thumb>http://thegamesdb.net/banners/fanart/thumb/895-3.jpg</thumb></fanart><fanart><original
wgamesdbidth="1920"
height="1080">http://thegamesdb.net/banners/fanart/original/895-4.jpg</original><vignette
wgamesdbidth="1920"
height="1080">fanart/vignette/895-4.jpg</vignette><thumb>http://thegamesdb.net/banners/fanart/thumb/895-4.jpg</thumb></fanart><boxart
sgamesdbide="front" wgamesdbidth="1280"
height="1803">http://thegamesdb.net/banners/boxart/original/front/895-1.jpg</boxart></Images></Game>')
