From: Ashwani M. <ash...@li...> - 2012-08-17 10:01:11
|
Hi, I still did not get it to run, even when passing the strings as bytearray-parametersto the stored procedure. I even checked that the generated bytearray has thecorrect encoding (WIN1252) by looking at the bytes.However, the bytes are either converted by the .Net provider or by the database before they "arrive" inside the stored procedure.Setting the ConnectionString-Charset or the Parameter-Charset to NONE orWIN1252 did not do anything either. Also tried setting the FbDbType to Textand Binary... Is there any conversion taking place when binary data is send to the databaseby the .Net Provider? Best regards,Ashwani Mehlem > Date: Fri, 17 Aug 2012 08:51:09 +0200 > From: di...@ci... > To: fir...@li... > Subject: Re: [Firebird-net-provider] Calling Stored Procedure with 'äüö' in parameter > > On Thu, Aug 16, 2012 at 9:51 PM, Ashwani Mehlem <ash...@li...> wrote: > > Would it help to use SQL-Parameters to avoid this problem? > > > > > > > > Example CommandText: > > > > > > > > "execute procedure test 'Zu speichernder Wert mit Umlauten äöü.';" > > Of course. You should always use parameters! > > -- > Jiri {x2} Cincura (x2develop.com founder) > http://blog.cincura.net/ | http://www.ID3renamer.com > > ------------------------------------------------------------------------------ > Live Security Virtual Conference > Exclusive live event will cover all the ways today's security and > threat landscape has changed and how IT managers can respond. Discussions > will include endpoint security, mobile security and the latest in malware > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |