Subject | Firebird 2.5 - UTF8 - UDFs |
---|---|
Author | |
Post date | 2013-03-04T15:08:52Z |
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]
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]