Strange text characters in query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bbatson
    New Member
    • Sep 2007
    • 46

    Strange text characters in query

    Hello,

    I am receiving strange text characters in a query linked to a back-end table with a memo text field. Below is the strange text that I am receiving in the query:



    Any ideas as to why this may be the case?

    Thanks!
  • PianoMan64
    Recognized Expert Contributor
    • Jan 2008
    • 374

    #2
    Is your backend Database something other than an Access Database?

    If so, you'll need to make sure that you have the language settings set correctly for the type of database that you're connected too. If you're using MS SQL, then you need to check the language settings. make sure that they are set to English, instead of Japanese, or chinese, which is what it looks like you have it set too.

    Hope that helps,

    Joe P.

    Comment

    Working...