AOWiki :: AODevs Forums :: Arcanum :: AO Official Forums :: AOC US/EU Official Forums
Welcome, Guest. Please login or register.
Did you miss your activation email?
+  AOdevs.com
|-+  AO 3rd Party Dev.» General Discussion» Yet another itemDB data issue...
Username:
Password:
 
Pages: [1]
  Print  
Author Topic: Yet another itemDB data issue...  (Read 407 times)
shadowgod
Administrator
*****
Offline Offline

Posts: 118



View Profile
« on: November 21, 2008, 00:21:41 »


 getting rather close to having a functional itemdb.  however, after attempting to do a new import to sql, a new error came up. and i cant figure out how to process this..

if i open up my .sql file in wordpad (250meg file), and go down to about where data stops getting imported to the sql db, theres a line, for a paid points vendor. and for its "info" (this would be where letter-based data for items is, such as pet spawns, where its some 4-char code) theres "c" followed by 3 'blocks'. i'm unable to copy/paste them, so i cant figure out what special chars these might be that wordpad isnt translating.  and thus, i dont know how to strip this out via my plugin.

infact, if i try to copy several lines above/below this part, and paste it to another file, it stops at that "c". so something about those special chars is blocking.

ideas?
Logged
Zacix
Invaleet
***
Offline Offline

Posts: 108


View Profile
« Reply #1 on: November 21, 2008, 08:24:54 »

It' might be 3 unicode characters. Wordpad should support unicode, but when you write the file, make sure that you are in fact writing unicode. Might also work if you open the file and "save as" and choose unicode as format, then reopen the file.
Logged
shadowgod
Administrator
*****
Offline Offline

Posts: 118



View Profile
« Reply #2 on: November 21, 2008, 15:50:32 »


opened the file in hex editor, and each of the chars is '00'. so logic suggests that its three NULL characters. and i'm not sure what to make of it. i suppose i can prolly add a check to just exclude those chars from being written to my output file..
Logged
Pages: [1]
  Print  

 
Jump to:  

Page created in 0.437 seconds with 18 queries.