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
