Karen,Notepad++ is open source. Find it at http://notepad-plus-plus.org/ Jim Bentley, American Celiac Society
1-504-737-3293 ________________________________ From: MikeB <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Saturday, March 29, 2014 9:21 AM Subject: [RBASE-L] - Re: Import chinese characters? It's NotePad++ [one word]. Google will find many download sites for you. > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Karen > Tellef > Sent: Saturday, March 29, 2014 9:57 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Import chinese characters? > > 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 <hope@cvbt- > web.org> > 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 > Menu>Encoding>correctly Convert to UTF-8 = The Thai will appear > Menu>Encoding>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 < mlindner@lindner- > law.com> 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]?> ] 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 > > > > > >
