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 <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 >
