#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Posts
    4
    Rep Power
    0

    Thumbs down Firebird Varchar Fields


    Greetings

    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!

    Much appreciated!

    Donovan
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2012
    Posts
    2
    Rep Power
    0
    Originally Posted by Donovan4319
    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 would say i has to do with collations.
    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.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2006
    Location
    Plovdiv. Bulgaria
    Posts
    226
    Rep Power
    12
    Also check Firebird's installation directory/misc/upgrade/metadata and read the docs there.

IMN logo majestic logo threadwatch logo seochat tools logo