Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    1

    Unanswered: Inserting Cyrillic Chars (УЛ.КУЙБЫШЕ) into DB

    We are trying insert Cyrillic Chars (Like: УЛ.КУЙБЫШЕ) into DB2 Database from java MDB .But we are not able to insert exact chars to the specified CHAR TYPE field. Can any one help me.....

    Ex: db3 " update ANAGRAFICA_CLIENTE set NICKNAME='УЛ.КУЙБЫШЕ' where PREF_CLIENTE='IT01' and COD_CLIENTE='0001050'"

    the output I am getting is spaces insted of cyrillic chars

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    this is an old issue
    have some look at
    Setting Up a Mixed-Byte Character Set (MBCS) Database on an English OS in DB2 UDB Version 8
    this sample is for japanese but also applies to other languages
    we had the same problem with a customer that wanted to handle international and cyrillic characters. but the problem has been resolved with settings also in browser and in webfocus..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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