Eureka, I think.
Jun. 1st, 2007 12:33 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
poltr1After 36 hours of disk analysis, and a half hour of index building, I was able to copy my old email files from the bad hard drive to a good hard drive. I also found some old SQL queries I had saved in TOAD, which didn't get backed up because they were saved in the same directory as the program. (I hate when programs do that.) I'll find out for sure when I bring everything in tomorrow.
For now, I'm content.
Had a bug report come in today. Someone was using a special character (specifically, an umlauted vowel) in a city name. While the HTML form enforced the 20-character limit on the field, the Oracle database saved the umlauted vowel as two characters, not one, resulting in a data overflow for that field. It won't try to save 21 characters in a 20-character field. I don't know if there's something we need to do with the database, or if I'll need to modify the query to strip them out.
For now, I'm content.
Had a bug report come in today. Someone was using a special character (specifically, an umlauted vowel) in a city name. While the HTML form enforced the 20-character limit on the field, the Oracle database saved the umlauted vowel as two characters, not one, resulting in a data overflow for that field. It won't try to save 21 characters in a 20-character field. I don't know if there's something we need to do with the database, or if I'll need to modify the query to strip them out.
