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 <mailto:[email protected]> Sent: Friday, March 14, 2014 12:46 PM To: RBASE-L Mailing List <mailto:[email protected]> 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 <mailto:[email protected]> Sent: Friday, March 14, 2014 12:28 PM To: RBASE-L Mailing List <mailto:[email protected]> 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
