Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

Strange characters in Access 2003/2007 row

I have a Visual Basic 6 application connected to an Access 2003 database and, sometimes, when I save a register, strange characters appear in the row of the database.

The characters are like this: Žþ or C2051, and only appear in the text fields.

Any suggestions?
0
ReaL10
Asked:
ReaL10
  • 3
  • 2
  • 2
  • +1
2 Solutions
 
puppydogbuddyCommented:
What is the nature of your application?  Are you importing or exporting CSV files that contain unicode characters?

Strange characters in memo fields could be a symtom of corruption-  see this link:
          http://allenbrowne.com/ser-47.html
0
 
ReaL10Author Commented:
No, I don't import nothing in this table.

This table have the lines of the sales order, and I have a form to enter the information in the application.
0
 
hesCommented:
Are you getting extra data from some type of scanner in the sales data.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
ReaL10Author Commented:
No, I have a simple form with head data and lines data ot sales order, and usually works all right, but sometimes appear this characters in the table of the database.
0
 
hesCommented:
Where does the sales data come from ?
0
 
ReaL10Author Commented:
Data are manually input by users through the form.
0
 
BrianVSoftCommented:
Sounds like a Unicode problem.. Check that the fields have unicode set to Off..
One trick is to (on a test backup copy) convert the database to Access-97 (Tools menu / Database Utilities) - Then convert that back to 2000 or 2003.. That can fix some things that a "Repair Database" can't.

Also look for and uninstall any "Language packs" that may be installed. We had a rogue pack once that was converting some VB text into German.
0
 
BrianVSoftCommented:
You should also have a look at this question.. He also had language pack problems in Access & strange characters..
Link is..
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_24275856.html

His final comment below might give you an idea..

Dear mdougan,
I think I found the solution finally, here is what I did:
I checked the regional settings of the 2 computers, and found some differences:

    * From Languages TAB, then click [Details] button, then select Settings tab and in Installed services select Arabic (Egypt) from the drop down list and select code page 102
    * In Languages tab select Arabic (Egypt) from the drop down list of languages for non-unicode programs
    * In the same tab check the following code pages (10004 MAC Arabic / 708 Arabic-ASMO / 864 OEM Arabic) and it worked OK
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now