Re: [U2] c#/uniobject/chinese/spanish characters
Doug, I wrote a couple short extension methods which convert from Arabic to UTF-16 and back. The pattern goes like this: - Get input from GUI - Convert from known code page to utf-16, in this case that's windows-1256 - Save the data into MV ... it's just text and doesn't get munged on the wire To display in GUI: - Read the text from MV - Convert back from utf-16 to original code-page - Display in GUI I believe you would just substitute a different code page for other languages - obviously it must be the same language going in both directions, this isn't Bablefish. ;) It works great for platforms that have no I18N or other language support. This dealer in Amman Jordan has 40 old mvBase systems in the field that are now adopting a GUI based on mv.NET and this small bit of code. I don't think you can sort or select on this kind of data in MV. Although once it was in the DBMS, I think we were able to see everything great with AccuTerm in a character interface. It works in D3 too. I didn't try any others. U2 might support a better storage mechanism, so let's see what others say. But I'll be happy to provide the C# code that does the translation. Just email me. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms From: doug chanco Subject: [U2] c#/uniobject/chinese/spanish characters anyone care to share any suggestions on the best way to create pick records that include chinese/spanish characters via c# and uniobjects or just c# and writing to a unix file? I have some ideas I am mulling around in my head but I thought I'd tap into the vast knowledge base available on here. I am basically looking at creating a pick record (or a unix one) that is a mixture of html and text (in english/chinese and spanish). any thoughts/suggestions are extremely welcomed ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] c#/uniobject/chinese/spanish characters
We process and store most of our info in utf-8 - this includes multiple European languages, not currently Chinese tho but that should not be an issue if it is encoded in utf-8. We also use uniobjects.net with this data no problem. Well I say no problem - you do have to make sure your lang settings are correct, and that you know in your code if you are dealing with utf-8 encoded data or not - otherwise you can get tied up. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: 05 April 2013 03:49 To: U2 Users List Subject: [U2] c#/uniobject/chinese/spanish characters hi all, anyone care to share any suggestions on the best way to create pick records that include chinese/spanish characters via c# and uniobjects or just c# and writing to a unix file? I have some ideas I am mulling around in my head but I thought I'd tap into the vast knowledge base available on here. I am basically looking at creating a pick record (or a unix one) that is a mixture of html and text (in english/chinese and spanish). any thoughts/suggestions are extremely welcomed thanks dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] c#/uniobject/chinese/spanish characters
Also if you are running u2 on linux the iconv utility (not the u2 ICONV, linux iconv) is essential when dealing with different character encodings. But there are a few undocumented features on here called //TRANSLIT and //IGNORE that it is worth googleing about. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 05 April 2013 08:05 To: u2-users@listserver.u2ug.org Subject: Re: [U2] c#/uniobject/chinese/spanish characters Doug, I wrote a couple short extension methods which convert from Arabic to UTF-16 and back. The pattern goes like this: - Get input from GUI - Convert from known code page to utf-16, in this case that's windows-1256 - Save the data into MV ... it's just text and doesn't get munged on the wire To display in GUI: - Read the text from MV - Convert back from utf-16 to original code-page - Display in GUI I believe you would just substitute a different code page for other languages - obviously it must be the same language going in both directions, this isn't Bablefish. ;) It works great for platforms that have no I18N or other language support. This dealer in Amman Jordan has 40 old mvBase systems in the field that are now adopting a GUI based on mv.NET and this small bit of code. I don't think you can sort or select on this kind of data in MV. Although once it was in the DBMS, I think we were able to see everything great with AccuTerm in a character interface. It works in D3 too. I didn't try any others. U2 might support a better storage mechanism, so let's see what others say. But I'll be happy to provide the C# code that does the translation. Just email me. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms From: doug chanco Subject: [U2] c#/uniobject/chinese/spanish characters anyone care to share any suggestions on the best way to create pick records that include chinese/spanish characters via c# and uniobjects or just c# and writing to a unix file? I have some ideas I am mulling around in my head but I thought I'd tap into the vast knowledge base available on here. I am basically looking at creating a pick record (or a unix one) that is a mixture of html and text (in english/chinese and spanish). any thoughts/suggestions are extremely welcomed ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] c#/uniobject/chinese/spanish characters
I'll cast another vote for UTF-8. This mechanism for storing and transmitting Unicode data is elegantly designed, and it should be usable in almost any legacy system that allows 8-bit data. Take a look at its byte value allocations: * Hex-00 through hex-1F are standard control characters, like ASCII. * Hex-20 through hex-7F exactly match ASCII. * Hex-80 through hex-9F are not used, because they might conflict with high (C1) control codes. * Hex-A0 through hex-FF are used in various combinations to represent international characters; EXCEPT * The codes for multi-value mark, etc., are not used. * It's a stateless system; that is, it doesn't phase shift from one scheme to another. Unicode data stored this way can include English, Russian, Chinese, Turkish, Braille, Byzantine musical symbols, and on and on. The precautions you must take, off the top of my head, are: * You can't assume that one byte of storage represents one character or one screen cell. * You must be careful not to break a character in half (or thirds, etc.) * You must be careful with anything that inputs or outputs data, to make sure it works in UTF-8. By the way, our terminal emulation (Anzio) and printing programs (Print Wizard) handle UTF-8 very well. On Fri, 5 Apr 2013, Symeon Breen wrote: We process and store most of our info in utf-8 - this includes multiple European languages, not currently Chinese tho but that should not be an issue if it is encoded in utf-8. We also use uniobjects.net with this data no problem. Well I say no problem - you do have to make sure your lang settings are correct, and that you know in your code if you are dealing with utf-8 encoded data or not - otherwise you can get tied up. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: 05 April 2013 03:49 To: U2 Users List Subject: [U2] c#/uniobject/chinese/spanish characters hi all, anyone care to share any suggestions on the best way to create pick records that include chinese/spanish characters via c# and uniobjects or just c# and writing to a unix file? I have some ideas I am mulling around in my head but I thought I'd tap into the vast knowledge base available on here. I am basically looking at creating a pick record (or a unix one) that is a mixture of html and text (in english/chinese and spanish). any thoughts/suggestions are extremely welcomed thanks dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] c#/uniobject/chinese/spanish characters
On 05/04/2013 23:37, Bob Rasmussen wrote: * The codes for multi-value mark, etc., are not used. iirc, if you use UV NLS (and presumably UD too) the mark characters have UTF-8 values assigned. Don't have a clue what they are, though. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] c#/uniobject/chinese/spanish characters
It's a critical point, and worth verifying. If someone will verify what UV NLS does, that'd be great. In the Unicode manual, it states that in UTF-8, no byte can have a value higher than hex-F4. On Sat, 6 Apr 2013, Anthonys Lists wrote: On 05/04/2013 23:37, Bob Rasmussen wrote: * The codes for multi-value mark, etc., are not used. iirc, if you use UV NLS (and presumably UD too) the mark characters have UTF-8 values assigned. Don't have a clue what they are, though. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] c#/uniobject/chinese/spanish characters
hi all, anyone care to share any suggestions on the best way to create pick records that include chinese/spanish characters via c# and uniobjects or just c# and writing to a unix file? I have some ideas I am mulling around in my head but I thought I'd tap into the vast knowledge base available on here. I am basically looking at creating a pick record (or a unix one) that is a mixture of html and text (in english/chinese and spanish). any thoughts/suggestions are extremely welcomed thanks dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] c#/uniobject/chinese/spanish characters
way easier, + CREATE-FILE DICT BLOB + edit voc entry to create a VOC file pointer to a ../udir/blob on line 002 + write said files to file BLOB keeping the record keys in a pick record, + open 'BLOB' as a file, OS thinks it is a Type 1 file, to READU, SELECT, SORT etc + !!!DO NOT!!! READ record (unless you want to trash the file and possibly your whole system!) , but can select, sort, etc on key. + !!!DO NOT!!! ADD DICT ITEMS to access any part of the record, including I type size (eg in line 2) dict items. + If needing to store more detail about each file, eg EXIF, write it into an X coded dict item with the same key as the DATA record (naughty, but possible, and keeps everything in the same file (or at least it looks like it does!). The 'X' code is ignored by the LIST DICT. +++ eg 001 X +++002 1024x728 +++003 Canon PS280 +++...etc... +++ + If needing to store more detail to SORT each file, add it into a composite key (ideal), or worst case, have a separate tag file + + The O/S can auto load the correct external app when 'filename' is 'echo'ed from a BAT / BASH as long as filename has the correct suffix. On 5 April 2013 12:49, doug chanco d...@chancofamily.com wrote: hi all, anyone care to share any suggestions on the best way to create pick records that include chinese/spanish characters via c# and uniobjects or just c# and writing to a unix file? I have some ideas I am mulling around in my head but I thought I'd tap into the vast knowledge base available on here. I am basically looking at creating a pick record (or a unix one) that is a mixture of html and text (in english/chinese and spanish). any thoughts/suggestions are extremely welcomed thanks dougc __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users