Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database display changes

 
Anita S�rensen
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
When updating the database the original empty spaces between fields changes to "squares" in the database display in WordPad (Not in Notepad). Does it mean anything or is it just somthing I can ignore?

I'm using


and
 
Anne Crace
Ranch Hand
Posts: 223
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think you can safely ignore that. Word Pad and Word add word processing functionality whereas Notepad is a straight text editor. I suggest looking at the database file in a hex editor with an ASCII conversion chart so you will know exactly what is in there. It isn't all alpha numeric characters.
 
Xabier Martija
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That happends because initialy, the database contains textvalues with blank spaces (0x20) trailing.
When you read the data, you normaly trim it.
When you write the data, you use:

That creates a byte[n] with n byte set to 0x00. 0X00 are not blank spaces.

_You can read this thread for more information.http://www.coderanch.com/t/189356/java-developer-SCJD/certification/null-terminated-text-values-DB
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic