Post reply

Chinese Simplified font

  • April 20, 2005 at 7:38 pm

    #163370

    Dear friends,

    I have a problem with fonts. In our system we receive datafeed files from Oracle ERP in the form of .TXT files. We receive supplier information from all parts of the world and so the supplier name will be in the native characters. Look at the example below:

    3289096Y01!GSKT,ACOUSTIC,,URETH FM,,6.95M!40000!.11!10475!ÃÀʱ¹¤Òµ²ÄÁÏ(Ìì½ò)ÓÐÏÞ¹«Ë¾!04/03/2005-03:12:54!CNY!JV2!2!03/01/2005-15:23:30!MRP LOCAL!Goods!PWE404127!

    The above text is a line from one of our datafeed files from China. The supplier name (highlighted) is actually in chinese character. But when it comes in a txt file it turns out to be funny characters. The Supplier table is capable of holding unidcode (datatype is nVarchar) characters, but when my loader script (vb script) loads it to the table, it load it in the above format. I want to translate it to chinese simplified before loading it to the table.. is there a way to do it?

    Thanks in advance,

    -Hari

    Kindest Regards,

    Hari

  • April 20, 2005 at 8:01 pm

    #553959

    Try to save as the text file to unicode encoding before loading.

  • April 20, 2005 at 8:11 pm

    #553961

    Hi friend, tried that but the funny characters are not getting changed.

    Kindest Regards,

    Hari

  • April 20, 2005 at 11:21 pm

    #553971

    Assume you have chinese character installed in the machine.

  • April 20, 2005 at 11:35 pm

    #553972

    yes i do..

    If I follow the steps below I can translate to chinese characters:

    >Open excel

    >Open the text file and when it prompts for encoding type to be applied for the columns, on choosing 'Chinese simplified', the supplier name changes to chinese word

    I can't do this for every file I receive bcoz the files are sent from Oracle and no.of files that are received are not fixed. My loader script runs twice a day to load these data. So the solution am expecting is, something to do in the script or to do in the SQL server.

    Thanks

    Kindest Regards,

    Hari

  • April 21, 2005 at 12:47 am

    #553985

    what tool to execute the script? Some posts here indicates that.

  • April 21, 2005 at 1:49 am

    #554002

    I use VB Script to load the data

    Kindest Regards,

    Hari

  • April 26, 2005 at 11:36 pm

    #555090

    Hi,

    There is a very simple solution for this problem.

    If u r using Windows Xp then proceed as follow

    1) Control Panel

    2) Regional and Language Setting

    3) Advanced

    4) Language for Non Unicode Program

    4a) Select  Chinse RPC from list

    5) Ok

    6) Reboot machine

     

     

    Tahir ( tahir275@hotmail.com)

    Kindest Regards,

    Tahir

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply