This is procedure



...................

DECLARE VARIABLE MESSAGE_CONTENT TYPE OF NVARCHAR(255) UNICODE_FSS;

...................

SELECT MESSAGE

FROM MESSAGES

WHERE ID = 2

INTO :MESSAGE_CONTENT;



EXCEPTION EX_GENERAL MESSAGE_CONTENT;

...................



My code:

Try

{

FbCommand.ExecuteNoneQuery();

}

Catch(Exception ex)

{

ShowMessage(ex.message);

}





SuperServer





Embedded





-----Original Message-----
From: firebird-net-provider-bounces@...
[mailto:firebird-net-provider-bounces@...] On Behalf Of
Dean Harding
Sent: Tuesday, August 05, 2008 11:05
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] [firebird-support] Not convert to
UNICODE in Embeded



Pham Huu Le Quoc Phuc wrote:

> Thanks for your reply,

>

> When my program catches exception, it gets message property from

Exception.

> I sure 100% I write "correct code" because it works OK! on SuperServer.

> But when I connect by Embedded(with the same connection string, I just

> modify server type), message of Exception still UTF8. In my opinion, this

> bug in Firebird .Net

Please include a sample of the messages you get from SuperServer and

from Embedded.



As I mentioned in the last email, there is no such thing as a "UTF-8

string" in .NET -- strings are opaque. It is possible that .net provider

is interpreting the encoding incorrectly and you end up with garbage

instead, but I would need to see samples of the strings to confirm.



Also, on including samples of your code -- it's not about whether you've

written "correct code" or not, I do not doubt you. However code samples

help the developers to reproduce the problem themselves much more simply

than just a vague description.



Dean.





-------------------------------------------------------------------------

This SF.Net email is sponsored by the Moblin Your Move Developer's challenge

Build the coolest Linux based applications with Moblin SDK & win great
prizes

Grand prize is a trip for two to an Open Source event anywhere in the world

http://moblin-contest.org/redirect.php?banner_id=100&url=/

_______________________________________________

Firebird-net-provider mailing list

Firebird-net-provider@...

https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



[Non-text portions of this message have been removed]