Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Convert file from ANSI to UNICODE Expand / Collapse
Author
Message
Posted Friday, April 5, 2013 10:02 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:27 PM
Points: 327, Visits: 853
Also opened in notepad++, it says ANSI.
Post #1439336
Posted Friday, April 5, 2013 10:06 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 12:49 AM
Points: 645, Visits: 1,847
Does your notepad++ have a hex editor?

In Ultraedit I can see the hex value of the bytes, and I can clearly see in a unicode file that there are 2 bytes for each character. (I click on a character and 2 bytes are highlighted.)
Post #1439340
Posted Friday, April 5, 2013 10:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 5:47 PM
Points: 1,781, Visits: 5,666
cast your column as unicode

MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1439343
    Posted Friday, April 5, 2013 10:27 AM
    Old Hand

    Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

    Group: General Forum Members
    Last Login: Wednesday, July 23, 2014 2:27 PM
    Points: 327, Visits: 853
    David, I downloaded ultraedit. Is unicode file always shows in hexadecimal? I did what you suggested and when I click on 1 character, two bytes are highlighted. But when I opened a non-unicode file, it doesn't open up in hexadecimal.
    Post #1439351
    Posted Friday, April 5, 2013 2:05 PM
    Old Hand

    Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

    Group: General Forum Members
    Last Login: Wednesday, July 23, 2014 2:27 PM
    Points: 327, Visits: 853
    I am using the following swtich in BCP.

    -w -T -t"|" -r"" -c -q

    Seems like one switch is overiding the other. File looks different but enocoding hasn't changed to unicode.
    Post #1439465
    Posted Friday, April 5, 2013 2:11 PM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Yesterday @ 5:47 PM
    Points: 1,781, Visits: 5,666
    SQL_Surfer (4/5/2013)
    I am using the following swtich in BCP.

    -w -T -t"|" -r"" -c -q

    Seems like one switch is overiding the other. File looks different but enocoding hasn't changed to unicode.


    Yes, the "-c" switch means use ANSI, get rid of it.


    MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1439468
    Posted Friday, April 5, 2013 2:27 PM
    Old Hand

    Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

    Group: General Forum Members
    Last Login: Wednesday, July 23, 2014 2:27 PM
    Points: 327, Visits: 853
    That worked. Thanks for all of your help.
    Post #1439478
    Posted Monday, April 8, 2013 12:29 AM
    SSChasing Mays

    SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

    Group: General Forum Members
    Last Login: Today @ 12:49 AM
    Points: 645, Visits: 1,847
    SQL_Surfer (4/5/2013)
    David, I downloaded ultraedit. Is unicode file always shows in hexadecimal? I did what you suggested and when I click on 1 character, two bytes are highlighted. But when I opened a non-unicode file, it doesn't open up in hexadecimal.


    Several days too late...but it's Ctrl-H to view a file in Hex mode in ultraedit.
    Post #1439693
    Posted Friday, April 19, 2013 3:47 AM
    Forum Newbie

    Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

    Group: General Forum Members
    Last Login: Friday, July 4, 2014 3:22 AM
    Points: 6, Visits: 9
    SQL_Surfer (4/5/2013)
    How can we convert ANSI files to UNICODE?

    You can convert ANSI files to Unicode format manually, but sometimes this may become very difficult if the PST files are large in size. To convert an ANSI PST file into Unicode format, first create a new Outlook data file in either MS Outlook 2003, 2007 or 2010 and then copy all the emails and other mailbox items from ANSI file to this new Unicode file. This really takes excellent technical knowledge, a lot of hard work and much time (especially when the files are large). I never tried this, I just read about this in an article. You may take help from this article.
    Other than this, there is one more effective solution for this situation. You can use third-party software to convert an ANSI PST file into Unicode format. There is a software named as SysInfoTools PST Upgrade & Downgrade that can easily convert ANSI PST to Unicode format and Unicode PST to ANSI format. I recommend you to check its free demo version before buying any other third-party PST converter.
    Regards.
    Post #1444292
    Posted Thursday, January 9, 2014 9:14 PM
    Old Hand

    Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

    Group: General Forum Members
    Last Login: Wednesday, July 23, 2014 2:27 PM
    Points: 327, Visits: 853
    '" -T -t"|" -r"" -c -q'

    With the switch above, some files are getting generated in ANSI and some are generated in UNICODE...If I want just ANSI, what change do I have to make?
    Post #1529632
    « Prev Topic | Next Topic »

    Add to briefcase ««123»»

    Permissions Expand / Collapse