Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Question Unanswered: Firebird Create Collation

    Hello all,

    I am working with Firebird 2.1.3 32bit Classic Server. I'd like works with chinese characters in UTF8 database. So I created database with UTF8 character set and I inserted chinese characters in unicode sequence form. Everything is OK, but I need sorting these chinese characters no by unicode but chinese collation. Firebird has GB_2312 character set where is GB_2312 and GB_2312_UNICODE collations.

    My question is : Can I create chinese collation (GB_2312) for character set UTF8? I tried use statement CREATE COLLATION ..... FOR .... from .... but this didn' t works for me . The UTF8 character set is not in fbintl.conf file.

    Does anyone have any idea?
    Thank's

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    I'm not sure what you are trying to achieve.

    According to the manual, you can only use the collation GB_2312 with the character set GB_2312. So you will need to change the character set of your database (or at least of that column which you want to sort by)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •