>> 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!
