April 19th, 2012, 07:43 AM
Firebird Varchar Fields
Hoping someone will be able to help me, i am really stumped.
I have a database application that stores data in multiple fields/, some of those fields the user can export to CSV format.
Now all was working great until i updated to Firebird 2.5, now for some reason when i export I get unknown chars in my varchar fields, the code hasnt changed at all, only difference is the firebird version.
I am still using Delphi 7 and i believe there are difficulties with the string conversion, but i dont understand how it can work in one version of Firebird but not the next?
Any pointers would be great!
April 19th, 2012, 12:36 PM
I would say i has to do with collations.
Originally Posted by Donovan4319
That is the translation of some particular chars for different languages.
Take a look at
http: / / www . destructor . de / firebird/charsets.htm
http: / / www . firebirdsql . org / refdocs/langrefupd21-ddl-collation.html
I hope may comment helps you find the cause.
April 20th, 2012, 02:31 AM
Also check Firebird's installation directory/misc/upgrade/metadata and read the docs there.