#1
  1. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    23

    Question Romanian chars(unicode) in firebird


    Anyone worked with Romanian chars (or Cyrillic) in firebird
    Delphi6+Firebird+windows ?
    ps: i'm new to unicode so need some examples
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    23

    Question


    1.created database with ISO-8859-2 charset
    2.I have tried to insert with ibexpert , it doesn't work sh tz became s and t
    3.Isql doesn't work (cmd.exe - windows console limits ?)
    4.I will make sql script in vim /notepad

    anyone worked with east european languages ?
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2004
    Posts
    12
    Rep Power
    0
    on ISQL you have to use following command:

    SET NAMES ISO8859_2;
    then
    CONNECT ...
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2004
    Posts
    1
    Rep Power
    0

    Or in FB 1.5.1...


    Starting with FB1.5.1 you can also connect with character set NONE and make all charset translations on the client side.

    This makes most sense, when the tool used for accessing FB has these conversions built in, like the .NET provider or KInterbasDB (the Python interface).

    Connecting with character set NONE is the only option when you have different, incompatible character sets in your tables, e.g. Cyrillic and ISO-8859-2.

    FB 1.5.1 RC3 download is at:
    http://firebird.sourceforge.net/down...release/1.5.1/

    Regards,
    Peter Jacobi
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Cape Town, South Africa
    Posts
    51
    Rep Power
    10
    For more info of Unicode and Firebird - try the yahoo support groups for firebird all the main brains hang out there.

IMN logo majestic logo threadwatch logo seochat tools logo