>> I have an EXCEPTION object with a Unicode text in it, a stored procedure
>> raises this exception.
>> The client application can view the Unicode text just fine when it
>> retrieves the Exception meta data, but when the exception is raised,
>> Firebird doesn’t seem to translate the text.
>> Any idea how to do this?
>
>Historically, RDB$EXCEPTION_MESSAGE has NONE charset, so it's never
>transliterated to the client charset. The engine simply has no idea that
>you stored UTF8 there. Sigh.

Oh bugger.

Now, I tried the following in the procedure to work around the above:

exception test _utf8 'unicode string here';

When I look at RDB$PROCEDURES.RDB$PROCEDURE_SOURCE I can see
the text is inserted as a hex string.

But this doesn't seem to work either?

Does this work at all with Exceptions?


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!