So how do you "re-enter the data"? Are you able to edit the data in the RBase table directly? If my original data is in an Excel spreadsheet, how can I get it into RBase? And can it reside in a Text datatype column along with the 99.9% of other data which is simple readable text? (I have about 15 rows out of thousands)
Karen -----Original Message----- From: hope <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, Mar 17, 2014 2:50 am Subject: [RBASE-L] - Re: Import chinese characters? When I moved my database from WinXP to Win7 some of my Thai characters became European characters (extended ASCII characters). I corrected this by changing the font to a Thai font. Any characters that came through as ?????? were lost completely. I had to re-enter the data. Any data manipulation (changing character encoding for example) needs to be done on the unconverted files. I can do this with Notepad++ On March 16, 2014 at 4:54 PM mlindner <[email protected]> wrote: Try looking at them with an old fashioned Hex editor that can read the raw data and tell you what the ascii or Unicode values would be. Mark Lindner Lindner & Associates NEW MAILING ADDRESS PO Box 327 Randolph MA 02368 781 247 1100 Fax 781 247 1143 EFAX 857 366 9691 Toll Free 888 658 4269 Direct 781 247 1160 Hours M-F 9:00 - 5:00pm THIS IS A COMMUNICATION FROM A DEBT COLLECTOR, ANY INFORMATION OBTAINED WILL BE USED FOR THAT PURPOSE. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of mbyerley Sent: Saturday, March 15, 2014 12:26 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Import chinese characters? Don’t have 64 bit installation to give you a “fer shure” on that, but ascii is ascii regardless of the number, so it is likely it is searchable. Maybe someone else can shed light on it for you... From: Karen Tellef Sent: Friday, March 14, 2014 12:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Import chinese characters? This isn't a 64-bit database. But just for my education, are BSTR just like text columns in that you can do the same searches "where column like .." and things like that? Like I said, 99.9% of the data is just text but there's maybe 20 records out of thousands that have a few characters. Karen -----Original Message----- From: mbyerley <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Fri, Mar 14, 2014 11:37 am Subject: [RBASE-L] - Re: Import chinese characters? UNICODE Requited. BSTR is the datatype you use for that column. From: Karen Tellef Sent: Friday, March 14, 2014 12:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Import chinese characters? I have imported a huge spreadsheet into a new database. We just now discovered that in one column there are some Chinese characters in a couple dozen rows. They imported as ????? for each character. I tested that if I create a table with a text column and a varchar column, that I cannot cut and paste, I still get the ???? There aren't many of these, and they won't be there going forward, but I'm wondering if there's any programming way that I can maintain these characters? Karen
