Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chinese Characters (2003 allSPs)

    I have a database with both English and Chinese Characters. When I export this to a txt file, the Chinese characters are replaced with ??'s. Is there a setting I need to change anywhere or am I seeking the impossible
    TIA
    Steve
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chinese Characters (2003 allSPs)

    What are you exporting? For tables and queries, you could use the method described in Example 3 in MSKB article ACC2000: Using SQL to Export to Unicode by Means of the Jet Provider and Text ISAM.

    For reports: when I export a report to text in Access 2002, the program asks me whether I want to export to Windows (ANSI), MS-DOS (ASCII) or Unicode format. ANSI and ASCII don't support Chinese characters.

    Also, does the text editor you use to view the .txt files support Unicode?

Posting Permissions

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