Hello Karen, sorry I'm a bit slow getting back to you; I don't check the List too often. The ???? that I had to re-enter were in form fields. I re-entered manually. I haven't done data in tables in awhile but if I remember correctly (checking my cryptic notes). You need to: unload the data from Excel (pain text, csv or tab delimited). You might need to do this on an XP machine. For Thai (I'm not sure about Chinese) Open a virgin file on the Win7 machine with NPP = the Thai will appear as Euro Characters. Menu>Encoding>Character Set>Thai>TIS-620 = The Thai will appear correctly Menu>Encoding>Convert to UTF-8 = The Thai will appear correctly (If "without BOM" is selected it won't) Save Then you can import/load it into Rbase.
NPP (Note pad ++) has Chinese encoding capability too. Reference Info: UTF-7 – a 7-bit encoding sometimes used in e-mail, often considered obsolete (not part of The Unicode Standard, but rather an RFC) UTF-8 – an 8-bit variable-width encoding which maximizes compatibility with ASCII. Windows NT (and its descendants, Windows 2000, Windows XP, Windows Vista and Windows 7), which uses UTF-16 as the sole internal character encoding. I expect you're running Win 7. If so, it should be able to handle Chinese as well as English on the same machine because of the character encoding. I don't know if you'll need to add some additional language to your regional settings. I believe Chinese is the second most used language; we'd better learn how to handle it. > On March 17, 2014 at 8:50 PM Karen Tellef <[email protected]> wrote: > > 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] > > > <mailto:[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]> > > [mailto:[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] <mailto:[email protected]> > > > To: RBASE-L Mailing List <[email protected] <mailto:[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 > > > > > > >
