Thanks for the reply! We haven't solved this yet. Yes the machine happens to be Windows 7. Never heard of a Note Pad++. Is that natively on windows 7 or do I have to download it somewhere? If I attempt this routine would you mind if I email you privately with questions so I don't gum up the list? If I find a solution then I would post to the list.
Thanks! Karen -----Original Message----- From: Center for Vocational Building Technology - Thailand <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Sat, Mar 29, 2014 6:47 am Subject: [RBASE-L] - Re: Import chinese characters? 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]> 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
