AW: Question(s) on converting names and addresses to UNICODE

Charles,

You're probably going to want to get the Text Extenders that are part of

5722-DE1.

http://www-01.ibm.com/software/data/db2/support/textextender/

In Release 6.1 there is a new free licence product 5733-OMF (Omnifind Text
Search).
Which allows an advanced text search, even in HTML or PDF documents.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Charles Wilt
Gesendet: Wednesday, 22. July 2009 17:14
An: Midrange Systems Technical Discussion
Betreff: Re: Question(s) on converting names and addresses to UNICODE

Alan,

You're probably going to want to get the Text Extenders that are part
of 5722-DE1.
http://www-01.ibm.com/software/data/db2/support/textextender/

Allows for better text searches, including "fuzzy" matches.

HTH,
Charles

On Wed, Jul 22, 2009 at 10:48 AM, Alan Shore<AlanShore@xxxxxxxx> wrote:

Thanks for your reply Duane
Even though we ARE going to 6.1, it is NOT in our near future, but the
conversion to UNICODE is
however, the process of indexing/searching names and is also something we
HAVE to look into as well
I've already asked the question "How are our customer service dept. going
to be able to process/analyze/investigate names and addresses in Arabic,
Mandarin, etc.
Have you been able to find anything?



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 07/22/2009 09:58:56 AM:

Alan;

We are looking at a project to re-architect our address and name
files, centralize and standardize them, UNICODE etc.

One of the things on my list to research is if the 6.1 support for
text indexing/searching would work for customer and/or business
names and aliases.

I have only done some cursory research on it but at the moment it
looks like it will fit our needs.

Duane Christen


--


        Duane Christen
Senior Software Engineer
(319) 790-7162
Duane.Christen@xxxxxxxxxx

Visit PAETEC.COM


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Wednesday, July 22, 2009 8:34 AM
To: Midrange Systems Technical Discussion
Subject: RE: Question(s) on converting names and addresses to UNICODE

Morning Neill
Thanks for your reply
Now its my turn to say
I hope I haven't misread your reply
We are passing the data to a 3rd party vendor software (looking back
at my initial e-mail I now realize I missed that important word -
software) This 3rd party  software is used in printing the invoice,
shipping label etc We have asked them what would it take for them to
process UNICODE fields.
There first question was, how long/big will these fields be Hence,
my question to the e-mail group


Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 07/21/2009 06:54:52 PM:

Do you really need to pass the data to a third party to convert it? Or

have

I misread the question.

Anyway if you want your fields to be Unicode you have a couple of

choices,

CCSID 1200, 13488 or 1208. The first two are effectively the same and

store

the values as UTF-16 the later is UTF-8 (which is becoming more
popular)

The rest of my answer depends on your answers to the following?

How many languages do you currently support?
What CCSID's are you using?
Are you prepared to recompile / refactor programs?
Whats your dev environment RPG COBOL, Synon site?

Neill

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: 21 July 2009 21:29
To: Midrange Systems Technical Discussion
Subject: Question(s) on converting names and addresses to UNICODE

Good afternoon all
I hope I can ask the correct question, so here goes We have been asked
to look into converting our Name and address fields

from

EBCDIC to UNICODE to capture "foreign" characters Part of that
conversion is the passing of said names and addresses to a

3rd

party vendor
This is NOT really a technical question per se, but I don't really
know where to start investigating the following question.

For ALL the names and addresses that have to be captured world wide
(in whatever characters that will be passed down), what would be
considered a good "size" for fields like first name last name Address
lines (including street names, city names, provinces, county

names,

country names etc. etc.)
Like I said - not really a technical question, but if someone knows
the answer, or can point me in the right direction, it would be MUCH
appreciated


Thanks in advance



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at

http://archive.midrange.com/midrange-l

.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.