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: disk...@cincura.net
> To: firebird-net-provider@lists.sourceforge.net
> Subject: Re: [Firebird-net-provider] Calling Stored Procedure with 'äüö' in
> parameter
>
> On Thu, Aug 16, 2012 at 9:51 PM, Ashwani Mehlem <ashwani.meh...@live.de>
> 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
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
