Subject Firebird 2.5 - UTF8 - UDFs
Author
Hello,



I turned my Firebird 1.5 database into Firebird 2.5 database (with the usefull FBClone (http://code.google.com/p/fbclone/).



Now I'm testing my application in Delphi 5 where my ib_connection.charset is now defined to WIN1252 and all seemed to work fine with the firebird 2.5 and utf8.

Until i tried to create a record where the field value was containing "€" and a trigger was on that table and working this value with a UDF, i received the error message : "malformed string at trigger ...."



The UDF was compiled with Lazarus on Windows 64-bits, because the firebird server is installed on windows 64-bits.



My question is : How should the UDF work with charsets ? Is there a specific way to create the UDF ? UDF are made for a specific charset ?



Thanks in advance!



Marianne Castel



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