|Subject||Re: [firebird-support] Re: Unicode text in Exception?|
|Author||Martijn Tonies (Upscene Productions)|
>> I have an EXCEPTION object with a Unicode text in it, a stored procedureOh bugger.
>> 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.
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?
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!